Partial Reload - Range of Variables in LOAD INLINE

Thu, 21 Jun 2012 09:12:03 GMT

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.

Re: Partial Reload - Range of Variables in LOAD INLINE

Thu, 21 Jun 2012 09:23:08 GMT

Nevermind got it!

Put $(variable name) for each variable.

topic Partial Reload - Range of Variables in LOAD INLINE in QlikView

Partial Reload - Range of Variables in LOAD INLINE

Re: Partial Reload - Range of Variables in LOAD INLINE