topic Re: Loading limited data amount via variable in QlikView

Loading limited data amount via variable

Wed, 11 Feb 2015 11:45:20 GMT

Hi there,

my name is Oliver, I'm from germany and I'm brandnew in the Qlik-Community.

Last week I had the courses QlikView Designer & Developer and now I'm so excited that I spend the hole day on QlikView

I built up the data modell and nearly everything works fine. Now I would like to do a little bit of fine tuning and for that I want to limit the amount of data. I don't want to do this with commenting and uncommenting "FIRST 100", so I thougt about an other possibility.

I try the following and for the first moment it seems to work well:

Let vLine = if($(vLimit) = '100','FIRST 100', '');

$(vLine)

TableName:

LOAD ...

On the surface there is an input box with a dropdown (vLimit -> 100;complete) wich allows me to make the selection.

But if I use this way, the code highlighting in the script "says" that there is a mistake and that irritates me (see screenshot).

Can someone give me a hint or tell me a better way?

Thanks in advance

Greetings from germany (Black Forrest)

Oliver

Re: Loading limited data amount via variable

jonathandienst — Wed, 11 Feb 2015 11:59:13 GMT

Oliver

The syntax check in the editor is quite sensitive to possible errors and it does not handle variable expansions in the code very well. The script itself runs properly, its just the editor. The only workaround that comes to mind in this case is this:

if $(vLimit) = '100' Then

else

end if

You do know that you can do this in the debugger? In the script editor, click the Debug button to start the debugger. This will give you breakpoints and limited loads as options.

HTH

Jonathan

Re: Loading limited data amount via variable

Wed, 11 Feb 2015 12:06:25 GMT

Hi Jonathan,

thank you for the very quick response.

OK, so I have to deal with the irritation or use the debugger.

Re: Loading limited data amount via variable

Wed, 11 Feb 2015 12:33:06 GMT

Sorry I'm ill at home - thats the reason of the autoreply

To get the correct syntax highlighting I tried to include the script, but I'm not familiar with including, so I get an error.

$(Include=$(SCRIPTPATH)limit100.txt);

TableName:

LOAD ...

Content of limit100.txt

Let vLine = if($(vLimit) = '100','FIRST 100', '');

$(vLine)

Error

Unknown statement

FIRST 100

I don't understand why I get this error. Perhaps I need some more basics about including scripts.

Can someone give me a hint please? Thanks in advance.

Oliver

Re: Loading limited data amount via variable

simospa — Wed, 11 Feb 2015 13:10:01 GMT

Hi, try this

Content of limit100.txt

Let vLine = if($(vLimit) = '3','First 3 ', '');

In load script:

//I setted vLimit = 3, you have to retrieve the value in the way you know

Set vLimit = '3';

$(Include=limit100.txt);

MyMonths:

$(vLine) LOAD * INLINE [

MonthsName, MonthsID, MonthsOrder

Jan, 1, 10

Feb, 2, 11

Mar, 3, 12

Apr, 4, 1

May, 5, 2

Jun, 6, 3

Jul, 7, 4

Ago, 8, 5

Sep, 9, 6

Oct, 10, 7

Nov, 11, 8

Dec, 12, 9

];

Pay attention: the correct syntax is FIRST 3 LOAD * .... and not LOAD FIRST 3 *

Let me know

Re: Loading limited data amount via variable

Wed, 11 Feb 2015 13:27:01 GMT

Hi Simone,

thanks for your help.

That works pretty good, but also confuses the syntax highlighting.

Seems to me, that I have to deal with...

Re: Loading limited data amount via variable

simospa — Wed, 11 Feb 2015 13:39:38 GMT

I see... it is tiresome... I think is a bug, like the one you get if you create a set analysis with -= operator...

Re: Loading limited data amount via variable

simospa — Wed, 11 Feb 2015 13:49:26 GMT

You could insert this script in a separated sheet of load script. You insert only this.

Then you continue to insert your application script in others sheets. Sintax errors seems live inside a specific sheet.

It's a trick, it can be useful?

Re: Loading limited data amount via variable

Wed, 11 Feb 2015 14:36:49 GMT

Hi Simone,

GREAT - That's it!

Very cool idea and very helpful for me. Thank you very much

Oliver

Re: Loading limited data amount via variable

simospa — Wed, 11 Feb 2015 14:48:27 GMT

You're welcome!

Rememeber to mark post as useful

Re: Loading limited data amount via variable

simospa — Thu, 12 Feb 2015 10:15:06 GMT

Oliver,

consider to mark post as solved 🙂

Re: Loading limited data amount via variable

Thu, 12 Feb 2015 11:15:50 GMT

Hi Simone,

I've marked the question yesterday as "possible solved" ("vermutlich beantwortet" in german).

Where can I mark it as finally solved?

Oliver

Re: Loading limited data amount via variable

simospa — Thu, 12 Feb 2015 11:30:11 GMT

In my reply, near Userful answer icon, you could find "Correct Answer" or similar.

Re: Loading limited data amount via variable

Thu, 12 Feb 2015 12:42:06 GMT

Hm... that was the answer which solved my problem.
For the rest I used my code as shown on top of the page.
Which one should I mark also? Sorry, I'm a newbie

Re: Loading limited data amount via variable

simospa — Thu, 12 Feb 2015 12:51:47 GMT

Try to click on "Markierung...", the other button would appear...

Re: Loading limited data amount via variable

Thu, 12 Feb 2015 13:11:06 GMT

If I'm unmarking "marked as useful" and click on "correct answer" there appears "Useful answer".

Hard to understand for me...learning QlikView is easier

Hope now everything is fine.

Re: Loading limited data amount via variable

simospa — Thu, 12 Feb 2015 13:13:34 GMT

Yeah! Great!

Thanks 🙂