Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

1 Solution

Accepted Solutions
Not applicable
Author

Nevermind got it!

Put $(variable name) for each variable.

View solution in original post

1 Reply
Not applicable
Author

Nevermind got it!

Put $(variable name) for each variable.