Comments for qlikblog.at

Comment on QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements … by Stefan Walther

Stefan Walther — Wed, 28 Jul 2010 09:11:00 +0000

I absolutely agree!! Best regards, Stefan

Comment on QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements … by George Beaton

George Beaton — Wed, 28 Jul 2010 08:42:18 +0000

I would still maintain that this would be so much easier and readable with a Case statement!

Comment on QlikTip #10: Zeilenumbruch in einer Textbox by Gunar Senf

Gunar Senf — Wed, 14 Jul 2010 07:42:41 +0000

Hallo Herr Walther,

was auch eine interessante Aufgabenstellung ist, wie kann man Text in Report bzw. im Sheet darstellen der mit einen Subset von HTML Tags formatiert wird.

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 - Brian's Travel & Photo Blog

Tue, 13 Jul 2010 12:44:30 +0000

[...] QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 :Admin, QV9, Server [...]

Comment on QlikView 9 – Überblick über Server und Publisher by Predrag

Predrag — Tue, 01 Jun 2010 10:27:33 +0000

is the new publisher able to read from a novell user directory service?

Comment on QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents by MarkSpizer

MarkSpizer — Mon, 03 May 2010 07:55:04 +0000

great post as usual!

Comment on A little tool for creating nested if-statements by Cristian Guedes

Cristian Guedes — Fri, 30 Apr 2010 13:52:12 +0000

What about expressions where the immediate expression is also an if statement. For example:

if([Número Tipo Fluxo]=0,

if([Número Tipo Documento]=1,

‘Cheque’,

if([Número Tipo Documento]=0,

‘Duplicata’,

[Item Fluxo]

)

[Item Fluxo]

)

Comment on QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents by tylerwaterfall

tylerwaterfall — Thu, 29 Apr 2010 17:21:39 +0000

Is there a way to undo this setting? A backout plan in case somehow this change to the registry negatively affects the QlikView environment.

Also, is the effect immediate or is a Server service restart needed?

Thanks for posting this!
Tyler

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by QlikCommunity | QlikTip # 18: A workaround for passing parameters to QlikView-macros - The QlikView Blogroll

Sat, 17 Apr 2010 14:00:36 +0000

[...] Possibly posts:QlikTip #17: Simulating the $(include) command in QlikView macros [...]

Comment on QlikTip # 18: A workaround for passing parameters to QlikView-macros by QlikCommunity | QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents - The QlikView Blogroll

Sat, 17 Apr 2010 14:00:02 +0000

[...] QlikTip # 18: A workaround for passing parameters to QlikView-macros [...]

Comment on QlikView 9 – Überblick über Server und Publisher by QlikCommunity | QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents - The QlikView Blogroll

Sat, 17 Apr 2010 13:59:37 +0000

[...] Possibly related posts:QlikView 9 – Überblick über Server und Publisher [...]

Comment on A little tool for creating nested if-statements by QlikCommunity | QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements … - The QlikView Blogroll

Sat, 17 Apr 2010 13:58:54 +0000

[...] Possibly related posts:A little tool for creating nested if-statements [...]

Comment on QlikTip #21: Running QlikView 8.5 and QlikView 9 side by side by QlikCommunity | QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 - The QlikView Blogroll

Sat, 17 Apr 2010 13:57:26 +0000

[...] Possibly related posts:QlikTip #21: Running QlikView 8.5 and QlikView 9 side by side [...]

Comment on QlikTip #7: Überprüfen, ob eine Tabelle existiert by Christian Hajdusic

Christian Hajdusic — Tue, 30 Mar 2010 08:07:36 +0000

Besteht auch die Möglichkeit im Script festzustellen ob eine Datei vorhanden ist. Konkreter Fall: ich möchte Daten aus einem CSV-File lesen, den es aber nicht unbedingt geben muss. Jetzt wäre natürlich schön, wenn keine Fehlermeldung beim LOAD kommt, sondern ich das im Script abfangen kann.

Vielen Dank im Voraus
Christian

Comment on A little tool for creating nested if-statements by o

Wed, 24 Mar 2010 03:22:11 +0000

Very good!

Comment on QlikTip #21: Running QlikView 8.5 and QlikView 9 side by side by Mike

Mike — Mon, 22 Mar 2010 12:30:04 +0000

Thanks for a wonderful post, l ve been looking for such information, I will join jour rss feed now.

Comment on QlikView 9 – Neue Objekte: Suchbox by Dominik

Dominik — Sat, 13 Mar 2010 10:52:14 +0000

Hallo Stefan,

ist es möglich mit einer Suche verschiedene Werte in verschiedenen Feldern auszuwählen, die den gleichen Datensatz aber andere Feldnamen haben?

Beispiel

Stadt Niederlassung Stadt Produktion
Dresden Dresden
München München
Hamburg Hamburg

An jede Stadt sind Latitude und Lonigute gebunden und über die Felder Latitude / Longitude sind die Felder Produktion und Niederlassung logisch verbunden.

Ich möchte die Auswahl treffen Niederlassung Dresden und Produktion München.

Vielen Danl

Comment on QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents by koff10

koff10 — Mon, 01 Mar 2010 15:31:28 +0000

Hi All,
I’m looking for how do add user and setup security in Qlikview server.
koff

Comment on QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements … by Paul

Paul — Sat, 13 Feb 2010 00:45:18 +0000

Sorry for trouble you. My email is paulyeo@tdstech.com

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by Stefan Walther

Stefan Walther — Fri, 12 Feb 2010 07:47:23 +0000

Hello Judi again,

first: please do me a favour and use the comment-functionality here only related to the topics of the articles; this is not a discussion forum (you can find one at http://www.qlikview.com/community); otherwise I will unfortunately have to delete your questions here. Certainly I will try to answer the mail you have sent me yesterday … but please not here for general questsions!!!

Regarding your questions:

* You can use the macro editor to create scripts
* Possible scripting languages are VBScript and Javascript
* “Dim a” would be possible but “Dim a as Integer” does not work because this is VB and not VBScript (in VBScript you do not have a type-declaration (read e.g. http://activexperts.com/axscript/vbscriptintroduction/)
* qvlib.msgbox(“xxx”) is not necessary if you use VBScript; in VBScript you can just use Msgbox(“xxx”); QVLib is a helper class if you use Javascript because in Javascript you do not have a corresponding functionality for messageboxes like MsgBox in VBScript

Hope this helps a little bit.
Best regards
Stefan

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by NANA

NANA — Thu, 11 Feb 2010 20:04:19 +0000

Hello,

I have a question, What is the best language to implement into QV so as certain basic statement work.
When I declare a variable like ” Dim a as Integer ” the VBScript engine don’t recognize Integer.
And In a QV model I saw ” qvlib.msgbox(” XXXX “). What is qvlib ?
VBScript is the only language to create macro in QV.

Best regards,

Judi.

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by Judi

Judi — Thu, 11 Feb 2010 12:03:32 +0000

Thanks a lot for your patient.

Best regards,

Judi.

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by Stefan Walther

Stefan Walther — Thu, 11 Feb 2010 12:01:40 +0000

Regarding your questions:

- you can find several demos at http://demo.qlikview.com (but unfortunately there’s no demo available only targetign logistics & transport)

- I do have some solutions; but they are not ready for publishing here (give me some time and I will publish them here).

Best regards
Stefan

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by Stefan Walther

Stefan Walther — Thu, 11 Feb 2010 11:58:01 +0000

You’re welcome!

Best regards
Stefan

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by Judi

Judi — Thu, 11 Feb 2010 11:17:07 +0000

Last questions…
Where can I found the qlikview demo about Logistics & Transport.
I’ll wish to have examples or models already realized.
Thanks.

Best regards,

Judi

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by Judi

Judi — Thu, 11 Feb 2010 11:01:39 +0000

Thank for helping.

Best regards,
Judi.

Comment on QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements … by Stefan Walther

Stefan Walther — Thu, 11 Feb 2010 08:12:21 +0000

Sorry, this is absolutely off-topic (not QlikView related). I’ll send you an eMail with some screenshots …

Best regards
Stefan

Comment on QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements … by paul

paul — Thu, 11 Feb 2010 07:56:32 +0000

Hi Stefan, Thank you very much for your reply. But when i try to create a new post , i unable to find where to upload QV doc, can you pls give me a few word how you do it ? apprecaite your sharing .
Paul

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by Stefan Walther

Stefan Walther — Thu, 11 Feb 2010 07:29:59 +0000

Hi Judi,

note that QlikView is primarily a *read only* analysis software.

There are is no builtin function for creating forms altough this can be done with the new feature “Real time update” introduced in QlikView 9. (Have a look at the chapter “Real-time data update” in the reference manual or “7. Using Automation for Dynami c Data Update” in the QlikView Automation Reference).

But note that there is not builtin functionality for creating forms, valdiating forms, so this would require quite a lot of custom code to achieve the required results.

There are some examples available at http://www.qlikview.com/community in the “Share QlikViews” section; just search for “update” there).

Hope this helps a little bit as a starting point …

Best regards
Stefan

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by Judi

Judi — Wed, 10 Feb 2010 15:11:43 +0000

Hi Stefan,

I want to create three buttons : NEW | UPDATE | DELETE

When I click on NEW button, I can edit customers informations (fname, lname, city,) by a validation form.
When I click on UPDATE button, I can update informations.
When I click on DELETE button, I delete entries.

Then, The NEW button add new entries in my SQL database and view last customer informations in the list
Then UPDATE button updates data on my table SQL SERVER.
Then DELETE button deletes entries

Afterwards I think there is all the condition doublon, etc.

Is it possible ?

Best regards.
Judi.

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by Stefan Walther

Stefan Walther — Wed, 10 Feb 2010 14:59:32 +0000

Hi Judi,

what exactly do you want to achieve with this form? Inserting & Editing data?

Best regards
Stefan

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 - The QlikView Blogroll - QlikCommunity

Wed, 10 Feb 2010 14:56:27 +0000

[...] QlikTip #17: Simulating the $(include) command in QlikView macros [...]

Comment on QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 by Judi

Judi — Wed, 10 Feb 2010 13:28:01 +0000

Hello,

I wish to create a qlikview form customers by the way of a macro VBS.

When I clik on NEW button, I have a customer form appears.

Is it possible to create this form with these informations :

Fname : | Lname : | Country City: | Company name : etc.

Thanks for your help.

Comment on QlikTip #21: Running QlikView 8.5 and QlikView 9 side by side by QlikTip #22: Restarting/Stopping/Starting services in QlikView 9 - The QlikView Blogroll - QlikCommunity

Wed, 10 Feb 2010 08:00:18 +0000

[...] Possibly related posts:QlikTip #21: Running QlikView 8.5 and QlikView 9 side by side [...]

Comment on QlikNews: QlikView im Time-Magazine by Nice Read #1: Gartner’s Magic Quadrants 2009/2010 and Qlikview - The QlikView Blogroll - QlikCommunity

Mon, 08 Feb 2010 13:04:06 +0000

[...] Possibly related posts:QlikNews: QlikView im Time-Magazine [...]

Comment on QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements … by Stefan Walther

Stefan Walther — Mon, 08 Feb 2010 11:42:20 +0000

Hi Paul,

it’s no plugin, it is just the standard Wordpress-functionality designed for my needs!

Best regards
Stefan

Comment on QlikTip #20: Why we do not need a SELECT-CASE/Switch-Case in QlikView load-statements … by paul

paul — Sun, 07 Feb 2010 13:59:27 +0000

Hi Stenfan , Nice work. May i ask what is the plug in you use for allow you upload sample QV doc in this post ? Hope you can give me the name.
Paul

Comment on QlikTip # 18: A workaround for passing parameters to QlikView-macros by Stefan Walther

Stefan Walther — Thu, 04 Feb 2010 18:20:22 +0000

No, I did not have the same experience before

Best regards
Stefan

Comment on QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents by Helmut

Helmut — Thu, 04 Feb 2010 11:41:44 +0000

Hi Stefan,

do you also know a way to suppress the dialog when using OCX Clients?
I seems to me that when using OCX as Client the “Always use this …” Option dosen’t work also.

Best regards
Helmut

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by forex robot

forex robot — Tue, 02 Feb 2010 06:01:54 +0000

nice post. thanks.

Comment on QlikTip # 18: A workaround for passing parameters to QlikView-macros by Meseker

Meseker — Fri, 29 Jan 2010 19:00:28 +0000

The question was not to reproduce it for me but merely if you had this same experience before!

Comment on QlikTip # 18: A workaround for passing parameters to QlikView-macros by Stefan Walther

Stefan Walther — Fri, 29 Jan 2010 12:09:57 +0000

Sorry, I can’t reproduce this behaviour!

Best regards
Stefan

Comment on QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents by Stefan Walther

Stefan Walther — Fri, 29 Jan 2010 12:08:39 +0000

Hi Hector,

no, this is a misunderstanding!!!!
The script posted in this article is not to be used in QlikView-files!
This is a script for adding some settings (keys) to the windows-registry!

Maybe I have not mentioned this clearly in the article:
You have to save the content in the script to a .vbs-file, then you can execute the file and the keys will be added to the registry.
Before executing the VBScript-File do not forget to change the constand SERVER_NAME to your server!

Hope this helps!

Best regards
Stefan

Comment on QlikTip #19: Suppressing Macro-Security (Module Security) Dialog on QlikView-Server/QlikView-Documents by Hector

Hector — Wed, 27 Jan 2010 22:21:32 +0000

Question, about tip #19, do I have to include this script in every single qlikview document I publish in my server?

Hector

Comment on A little tool for creating nested if-statements by Stefan Walther

Stefan Walther — Mon, 25 Jan 2010 16:39:00 +0000

Hi Ralf again,

Hmmm, yes sure, you are right … interesting discussion which brings me to new ideas … Yes, maybe I should really try to bring my mindset away from tools like Visual Studio torwards to the possibilities available in QlikView …

Interesting … so far I have just thougt that can’t be the way some tools/add-ins should be realised … but maybe …

I will try TIQView within in the next days to have a look how you’ve manged this …

Thanks for your feedback, that was one of the main reasons I have switched my blog to English (even if we could have also made this discussion in German, isn’t it )

Best regards
Stefan

Comment on A little tool for creating nested if-statements by Ralf

Ralf — Mon, 25 Jan 2010 16:28:01 +0000

Stefan,
there is no problem to do things like that in QV. We did it in TIQView for data profiling.
You can display the fields for selection and build script code from that selection and input variables (for expressions e.g.). Then, you could include this piece of code as external script
$(Include = filename.qvs)
or interpret a whole load statement in a variable just like this:
table: $(load_statement);
So, I see no problem except some efforts…
- Ralf

Comment on A little tool for creating nested if-statements by Stefan Walther

Stefan Walther — Mon, 25 Jan 2010 16:12:05 +0000

Hi Ralf,

thanks for your detailled answer.
And a big from me.

Yes, those features would be nice and would be a real improvement for developing QV-applications.
And I have so many similar ideas in mind, but as you know, unfortunately QV does not offer a plugin- (or AddIn) mechanism for the IDE like other vendors or tools are offering (like Visual Studio …). Unfortunately …

I know, some offline-tools like the one I have created are not the best way and they can only help in some (very limited) situations … unfortunately again …

So maybe, maybe in the future we can think about those features again …

Best regards
Stefan

Comment on A little tool for creating nested if-statements by Ralf

Ralf — Mon, 25 Jan 2010 16:01:50 +0000

Hi Stefan,

I’m thinking about a script generator inside QV where you can use the loaded data structure (all loaded fields) for selection of conditions in combination with a similar IF constructor. Every condition (rule) would create a flag (1/0 for false/true) which can be summarized. The combination of conditions (rules) could be lead into new flags by multiplying (flag1 * flag2).
A second stacked LOAD statement can aggregate all flags and measure the severity of each rule
The IF nesting would be a good thing on top.

Kind Regards,
Ralf

Comment on QlikTip # 18: A workaround for passing parameters to QlikView-macros by Meseker

Meseker — Fri, 22 Jan 2010 21:50:06 +0000

Hi Stefan,

yes i meant the “Edit Module”

Best,
Meseker

Comment on QlikTip # 18: A workaround for passing parameters to QlikView-macros by Stefan Walther

Stefan Walther — Fri, 22 Jan 2010 08:48:34 +0000

Hi Meseker,

do you mean the “Edit Module” button?

Best regards
Stefan

Comment on QlikTip # 18: A workaround for passing parameters to QlikView-macros by Meseker

Meseker — Fri, 22 Jan 2010 05:25:15 +0000

Hi Stefan,

I have been using so far QlikView 8.5. I tried to install yesterday V9 without uninstalling the previous version but to a different folder in …\Program Files. It didn’t complain and everything looked fine. I tried to do what you did in your examples with the vValueToDisplay etc. and when I get to the point to add a new action to run a macro, QV just gave me the option to type in the name of the macro without the Edit Module… button. So I had to type in the name of the macro, come out of the wizard for creating the actions and went to the usual way of editing the module, tools\edit module. This works fine but why is the button not available anymore? Is it a common problem?

Thanks for your help
Meseker

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by paul

paul — Thu, 21 Jan 2010 13:26:18 +0000

Hi sir ,
Thank you for your reply.
Paul

Comment on QlikTip # 18: A workaround for passing parameters to QlikView-macros by Tweets that mention QlikTip # 18: A workaround for passing parameters to QlikView-macros -- Topsy.com

Thu, 21 Jan 2010 08:19:02 +0000

[...] This post was mentioned on Twitter by countnazgul, Stefan Walther. Stefan Walther said: New Blog-Entry: : QlikTip # 18: A workaround for passing parameters to QlikView-macros http://bit.ly/5OPgA6 [...]

Comment on A little tool for creating nested if-statements by Stefan Walther

Stefan Walther — Wed, 20 Jan 2010 08:54:00 +0000

Hi Ralf,

I had absolutely no problems with a nested if with 10 levels but I did not invest time to find some limits of the if-statements in QV.

Yes, I am using this for business-rules, but I am very interested how you would like to have the tool extended to support business rules!!! As also suggested above, if you giving me some more information on some requirements for business-rules (even maybe examples) I would happily do the coding work

Best regards
Stefan

Comment on A little tool for creating nested if-statements by Ralf

Ralf — Wed, 20 Jan 2010 08:40:56 +0000

Hi Stefan,
this is a very interesting approach! This could be extended to handle business rules in QV. Did you experience some limitations in nesting depth or line size?
- Ralf

Comment on A little tool for creating nested if-statements by Silky

Silky — Wed, 20 Jan 2010 06:09:21 +0000

Its really very good..!!
Good work….I appreciate that…!

Comment on QlikTip #4: Nicht benötigte Felder in QlikView löschen (Dynamic Reduce) by Stefan Walther

Stefan Walther — Tue, 19 Jan 2010 12:05:43 +0000

) Some patience please, this article will be translated soon …

Best regards
Stefan

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by Stefan Walther

Stefan Walther — Tue, 19 Jan 2010 12:02:59 +0000

Hi Paul,

what do you mean with “use include command for directory folder name”?

Do you mean that you would like to include all files (containing) macros which are located under a specific directory?

If you, yes sure, this would be possible: You would just have to create a macro for iterating all files within a folder and running the IncludeAndExecute command described in the article for every file.

Hope this helps!
Best regards
Stefan

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by paul yeo

paul yeo — Tue, 19 Jan 2010 06:41:02 +0000

Hi Stefan,
Thank you for post the QV doc file at share Qlikview , I will try to download and figure that is the include try to do ? By the way thank you for your info on word press . I will start one soon.
Just like to confirm if i want to use include command for directory folder name , it is possible ? still confuse on this power full command,.
Paul

Comment on QlikTip #1: Statusbox/Auswahlstatus in Excel-Export integrieren by QlikTip #1: Transferring Current Selections to Excel-Export (translated) - The QlikView Blogroll - QlikCommunity

Tue, 19 Jan 2010 00:18:50 +0000

[...] Possibly posts:QlikTip #1: Statusbox/Auswahlstatus in Excel-Export integrieren [...]

Comment on QlikTip #1: Statusbox/Auswahlstatus in Excel-Export integrieren by Stefan Walther

Stefan Walther — Mon, 18 Jan 2010 23:26:31 +0000

Hi Valdimir,

now I have translated the article to English – especially for you )

http://www.qlikblog.at/583/qliktip-1-transferring-current-selections-excelexport-translated/

Best regards
Stefan

Comment on qlikblog.at is now published in English! by QlikTip #1: Transferring Current Selections to Excel-Export (translated)

QlikTip #1: Transferring Current Selections to Excel-Export (translated) — Mon, 18 Jan 2010 23:20:07 +0000

[...] Excel-Export (translated)By Stefan Walther Leave a commentThis entry was posted in QlikTips While driving this blog only in German the most viewed article was “QlikTip #1 – Export the current celections to Excel”.So this [...]

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by Stefan Walther

Stefan Walther — Mon, 18 Jan 2010 07:19:37 +0000

Hi Vladimir again,

yes, I will share those libraries. But at the moment there are many other articles in the pipeline so it will take some time until there is a slot free for publishing these libraries

In the meantime: If there is something special you are looking for, just drop me an eMail and I’ll send you a part of these libraries …

Best regards
Stefan

Comment on QlikTip #15: Layoutraster im Entwurfsmodus verkleinern by Vladimir Sconza

Vladimir Sconza — Sat, 16 Jan 2010 13:40:20 +0000

Even if not written in English …

I have understood this and did not know that …
Really nice, love this functionality in QlikView …

There are so many u0nknown (or better said features that are not known by me) in QlikView that this is really amazing!

I really like your blog !!! Congratulations!

Greetings from Russia
& have a nice weekend!

Comment on QlikTip #4: Nicht benötigte Felder in QlikView löschen (Dynamic Reduce) by Vladimir Sconza

Vladimir Sconza — Sat, 16 Jan 2010 13:38:02 +0000

Sounds interesting, but I cannot really understand the content of this article (German only ).

Could you please translate this!

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by Vladimir Sconza

Vladimir Sconza — Sat, 16 Jan 2010 13:35:02 +0000

Hi Stefan,

in your article there is a screenshot at the bottom of the article where you include some libraries like

- ExcelHelper_v1.8.vbs
- MailingLibrary.vbs
- GUI_Library.vbs

It would be nice if you could share these libraries to all

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by Stefan Walther

Stefan Walther — Sat, 16 Jan 2010 12:39:46 +0000

Hi sir , I think you are trying to share with us how to use include how to org QV file. and i try to learn how to use this command. but after i down load your file which you attach in this post , i not sure how to open the 2 include file ? and i don’t knwo how to use it . can you pls share with me.

http://community.qlikview.com/forums/t/24218.aspx

Above link is one of the user try to also use include for org file. ( which i also not sure hwo to use it )
…
Paul

Hi Paul again,

some clarification.
The method described in this article is used for encapsulation and organizing your macro code in a better way.

What exactly did not work with my example.
Maybe you could give me some more details. Then I will be glad to help you …

Best regards
Stefan

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by Stefan Walther

Stefan Walther — Sat, 16 Jan 2010 12:07:57 +0000

One more question , may i know your blog allow you to do file attachment , how you do it , i like to start a blog same like you , can you share with me please .Paul

Hi Paul,

I am using the Wordpress blogging engine. All the features you need are there availble as a standard or by plugins. Just search for “Wordpress” and you’ll find thousands of articles …

Best regards
Stefan

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by paul

paul — Sat, 16 Jan 2010 07:50:04 +0000

Hi sir , I think you are trying to share with us how to use include how to org QV file. and i try to learn how to use this command. but after i down load your file which you attach in this post , i not sure how to open the 2 include file ? and i don’t knwo how to use it . can you pls share with me.

http://community.qlikview.com/forums/t/24218.aspx

Above link is one of the user try to also use include for org file. ( which i also not sure hwo to use it )

One more question , may i know your blog allow you to do file attachment , how you do it , i like to start a blog same like you , can you share with me please .

Paul

Comment on qlikblog.at is now published in English! by Babushka

Babushka — Fri, 15 Jan 2010 13:47:42 +0000

Excellent choice! Thanks for a good blog

Comment on QlikTip #17: Simulating the $(include) command in QlikView macros by Fábio Simões

Fábio Simões — Fri, 15 Jan 2010 12:15:05 +0000

Great tip!

Make more easy to organize macros script.

Comment on A little tool for creating nested if-statements by Vladimir Sconza

Vladimir Sconza — Thu, 14 Jan 2010 07:55:44 +0000

Hi Stefan,

thanks for your feedback … yes, I see … did not think about the complexity when having to parse existing if-statements …

But i really hope you will give the realization of this additional feature a second try. I have used your tool several times within the last days, and it is really nice. But when having to edit existing statements your tool unfortunately does not really help because one would need to import an existing if …

So I really hope that I will soon (or even bette sooner) read here about the new feature “Importing existing if-statements” … )

Nethertheless, thank you very much for your efforts!!!! Saves me a lot of time …

Comment on A little tool for creating nested if-statements by Stefan Walther

Stefan Walther — Thu, 14 Jan 2010 06:16:38 +0000

Sure …

Comment on A little tool for creating nested if-statements by rva

rva — Wed, 13 Jan 2010 19:57:34 +0000

I have some ideas, but I need to bring it to paper!
Give me some time

Comment on A little tool for creating nested if-statements by Stefan Walther

Stefan Walther — Tue, 12 Jan 2010 22:16:14 +0000

Hi rva (Roland ),

interesting idea, not really thought about that.
I am sure this would be a nice improvement for the tool, but at the moment I do not really have the clue how this should ideally included.

Do you have any concrete ideas how this could look like? If so we could make a deal: If you give me some further hints how the valuelist could be included I’ll do the coding work

Best regards
Stefan

Comment on A little tool for creating nested if-statements by rva

rva — Tue, 12 Jan 2010 22:00:34 +0000

Stefan,
I was thinking about doing something similar for the valuelist()-function. Do you have any plans to extend your app in this direction?

The function is sometimes useful when it comes to financial reporting (where you have generic dimension-values that are nowhere defined in the datamodel). However the syntax is more than horrible

Small example:


if (

  valuelist('Vorjahr','Gewähltes Jahr', 'Differenz') = 'Vorjahr',

  sum(if (inyeartodate(Bestelldatum,Stichtag,-1),Anzahl)),
  if (

    valuelist('Vorjahr','Gewähltes Jahr', 'Differenz') = 'Gewähltes Jahr',

    sum(if (inyeartodate(Bestelldatum,Stichtag,0),Anzahl)),

sum(if (inyeartodate(Bestelldatum,Stichtag,0),Anzahl)) - sum(if (inyeartodate(Bestelldatum,Stichtag,-1),Anzahl)) ) )

Comment on qlikblog.at is now published in English! by rva

rva — Tue, 12 Jan 2010 21:50:39 +0000

nice!

Comment on A little tool for creating nested if-statements by Stefan Walther

Stefan Walther — Tue, 12 Jan 2010 13:42:03 +0000

Hi Vladimir,

thanks for your comment.
Yes, you are right, this would be a nice feature and really, really useful. I have also tried to implement this, but unfortunately parsing an existing nested-if is not that easy as it seems to be. Therefore I would need a script-parser (or develop) one … and this is not an easy task, especially by using only Javascript (I have develped the little tool only with Html, CSS and JS to be platform independent) …

Unfortunately, but maybe I will at any future time have the clue how to code this …

Best regards
Stefan

Comment on A little tool for creating nested if-statements by countnazgul

countnazgul — Tue, 12 Jan 2010 07:39:33 +0000

Very good and useful work!

Comment on A little tool for creating nested if-statements by askyer

askyer — Mon, 11 Jan 2010 13:39:16 +0000

Very good!

Comment on A little tool for creating nested if-statements by Nested if-statements tool

Nested if-statements tool — Mon, 11 Jan 2010 10:14:47 +0000

[...] You can check it out here [...]

Comment on A little tool for creating nested if-statements by Vladimir Sconza

Vladimir Sconza — Mon, 11 Jan 2010 10:08:18 +0000

That’s cool
Good work – even if I’d wish there would also be an option for importing existing if statements …

Comment on QlikTip #1: Statusbox/Auswahlstatus in Excel-Export integrieren by Vladimir Sconza

Vladimir Sconza — Fri, 08 Jan 2010 20:10:16 +0000

I really hope that you’ll translate this article to english soon …
I think this should solve one of the current issues I have in our company …)

Best regards
V.

Comment on qlikblog.at is now published in English! by Stefan Walther

Stefan Walther — Fri, 08 Jan 2010 12:41:55 +0000

You’re welcome!
Greetings back from Austria.
Stefan

Comment on qlikblog.at is now published in English! by Vladimir Sconza

Vladimir Sconza — Fri, 08 Jan 2010 12:40:16 +0000

Dear Stefan Walther,

that are good news! Nice decision!

Best regards from Singapure
V.

Comment on QlikTip #14: Fehlende Layoutoptionen (Rahmen, abgerundete Ecken, etc.) by Stefan Walther

Stefan Walther — Thu, 07 Jan 2010 17:14:01 +0000

Have a look a the latest qlikblog.at – news.
I have decided to change the language of this blog, and within the next few weeks I will publish all existing articles translated into English here …

Best regards
Stefan

Comment on QlikView 9 – Neue Objekte: Suchbox by Stefan Walther

Stefan Walther — Wed, 06 Jan 2010 00:07:56 +0000

Hallo Lukas,

ja, klar, das geht:

- im Kontextmenü der Listbox auf “Advanced Search” gehen
- dann im Editor folgenden Suchbegriff eingeben:

=(Kundenname like '*GmbH') or (Kundenname like '*GesmbH')

Und danke für den Tipp … mir ist gerade bewusst geworden, dass dieser Suchdialog kaum bekannt ist … werde in Kürze mal darüber schreiben …

Schöne Grüsse

Stefan

Comment on QlikTip #6: Null-Values in Listboxen ausblenden by Mohammed

Mohammed — Mon, 14 Dec 2009 11:45:07 +0000

bei mir hat keine von den Formeln funktioniert, könnte daran vielleicht liegen dass ich kein Listbox habe sindern Tabellediagramm. gibt es vielleicht eine andere Lösung dass ich Zeilen ich die T-Diag nicht anzeigen lasse.
Danke und Viele Grüße
Mo

Comment on QlikView 9 – Neue Objekte: Suchbox by Lukas

Lukas — Tue, 01 Dec 2009 14:34:40 +0000

hallo.

Ist es in Qlikview irgendwie möglich, mehrere Werte auf ein Mal in einer Listbox zu suchen?

zB: Suche im Feld Kundenname:
alle Firmen die mit Gmbh (*Gmbh) oder GesmbH (*GesmbH) enden.

lg Lukas

Comment on QlikTip #14: Fehlende Layoutoptionen (Rahmen, abgerundete Ecken, etc.) by Stefan Walther

Stefan Walther — Fri, 30 Oct 2009 17:59:38 +0000

Hi jason & Marco,

in the meantime I have experimented a lot with the automated translation-engines like offered by Yahoo, Google and Bing. The google-translator is by far the best one, but unfortunately the google-translator has a bug and also translates the code I’ve posted here … so this messes up the most important information in many cases … unfortunately …

But stay tuned, I will offer a solution for the “language problem” in the very near future

Best regards

Stefan

Comment on QlikTip #12: Erweiterung des Store Into-Befehls in QlikView 9 by Stefan Walther

Stefan Walther — Tue, 20 Oct 2009 14:27:54 +0000

auch schon bemerkt … habe ich auch schon im Artikel aktualisiert …
Danke für die Bestätigung meiner Vermutung!

Stefan WALTHER

Comment on QlikTip #12: Erweiterung des Store Into-Befehls in QlikView 9 by Martijn ter Schegget

Martijn ter Schegget — Tue, 20 Oct 2009 14:15:36 +0000

Ich hab’s mal versucht mit XML export, aber das XML ist genau dasselbe als ein QVD-datei: zuerst eine Beschreibung des Strukturs, und dan (binär) die Daten.

MfG,
Martijn

Comment on QlikTip #14: Fehlende Layoutoptionen (Rahmen, abgerundete Ecken, etc.) by jasonseril

jasonseril — Mon, 19 Oct 2009 04:39:17 +0000

Hello Marco,

You can use the new Google Toolbar for Automatic Translation of the web/site. I’m using the toolbar right now and i can understand the content of this blog. Thanks

Comment on QlikTip #14: Fehlende Layoutoptionen (Rahmen, abgerundete Ecken, etc.) by Stefan Walther

Stefan Walther — Sat, 17 Oct 2009 21:27:02 +0000

Hallo Marco,

unfortunately (for you) I have decided to post my QlikView articles only in german language.
(Please have a look at http://www.qlikblog.at/english/ )

The reason for doing so is that this blog is primarily a service for my existing (and new) customers which are (at the moment ) only located in the german speaking area.

But in the near future I will add a feature here for every article: an english abstract, and if one of the article is requested for translation I will gladly translate it to english.

In the meantime: sorry, but if you think that a special article solves one of your problems, please tell me and I’ll post a translation to the blogs on http://community.qlikview.com.

Best regards
Stefan

Comment on QlikTip #14: Fehlende Layoutoptionen (Rahmen, abgerundete Ecken, etc.) by Marco

Marco — Sat, 17 Oct 2009 21:02:47 +0000

Hi, can you post in english ? I suspect your tips are great but cannot read them !!!!! buhhhh.

Comment on QlikTip #11: Einlesen von Ini-Dateien by Helmut Dollinger

Helmut Dollinger — Sat, 17 Oct 2009 10:18:32 +0000

… das habe ich gesucht, danke für die detailliere Beschreibung und die Lösung meines Problems

Gruss
H. Dollinger

Comment on QlikTip #1: Statusbox/Auswahlstatus in Excel-Export integrieren by Stefan Walther

Stefan Walther — Fri, 16 Oct 2009 15:33:29 +0000

Freut mich, dass mein Blog auch in der “Nicht-deutschsprachigen-Region” gelesen wird

mfg
Stefan WALTHER

Comment on QlikTip #6: Null-Values in Listboxen ausblenden by Stefan Walther

Stefan Walther — Fri, 16 Oct 2009 10:56:02 +0000

Siehe dazu auch:

http://community.qlikview.com/wikis/qlikview-wiki/isnull-difference-in-qv-64bit-and-32bit.aspx

Schöne Grüsse
Stefan

Comment on QV-Applikation: Interne QlikView Grafiken by Stefan Walther

Stefan Walther — Fri, 16 Oct 2009 09:51:57 +0000

Genau, weitere Hilfe-Applikationen von mir werden auch in Kürze folgen

Schöne Grüsse
Stefan

Comment on QV-Applikation: Interne QlikView Grafiken by Guido

Guido — Fri, 16 Oct 2009 09:49:54 +0000

Hallo Stefan,

die Hilfeapplikation (& andere) kann man sehr gut im Menü unter “Datei, Favoriten, Favoriten hinzufügen” in QlikView einbinden. So hat man immer schnell seine Lieblingsapplikationen zur Hand…

Gruß
Guido