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', '');
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?
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
<load with First 100>
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.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein