1 Reply Latest reply: Jun 21, 2012 5:23 AM by j_kleiman RSS

    Partial Reload - Range of Variables in LOAD INLINE

      Hi

       

      I have 5 sliders (linked to variables) in my QV model. I also have a chart which I would like to adjust the dimensions through a Partial Reload.

       

      This is my code in the load script so far:

       

       

       

      MatchTBL:

      REPLACE Load * INLINE

      [LowerLimit, UpperLimit, Status

      vLower1,(3*vLower1),VeryHigh

      vLower2,vLower1,High

      vLower3,vLower2,Medium

      vLower4,vLower3,Poor

      vLower5,vLower4,VeryPoor];

      IntervalMatchTBL:

      IntervalMatch(SALES) Load LowerLimit, UpperLimit RESIDENT MatchTBL;

       

      My chart uses Status as the dimension.

       

      I'd really appreciate it if anyone could spot the error here and put me on the right course.

       

      Thanks in advance.

       

      P.S I realise I can do this in Qlikveiw as a calculated dimension. However, the next chart which I will require will need it through this partial reload and a calculated dimension will not be possible. I'd like to sort out the problem before it arises.