Loading limited data amount via variable

[#1]

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

[simospa]

Oliver,

consider to mark post as solved 🙂

S.

[#3]

Hi Simone,

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

Where can I mark it as finally solved?

Oliver

[simospa]

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

S.

[#5]

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

[simospa]

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

S.

[#7]

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.

[simospa]

Yeah! Great!

Thanks 🙂

S.