16 Replies Latest reply: Feb 12, 2015 8:13 AM by Simone Spanio RSS

    Loading limited data amount via variable

      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