Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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];
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.
Nevermind got it!
Put $(variable name) for each variable.