max function in chart is ignoring dimension

Wed, 25 Nov 2020 16:16:04 GMT

I have a straight table where i have to show sum over a date range. The starting point of date is fixed (4th highest date) but end point variable. (like 7th or 10th highest date) depending on a field called SIT.

So, I store variable as vSIT = SIT

=sum({<W_Period={">=$(=max(W_Period,$(=vSIT))))<$(=max(W_Period,4))"}>}WS_Qty)

My dimension is Country. If I use the above expression , if I hard code then it is taking fine but when i pass variable it is taking maximum value of that field ignoring my country dimension. Please advice.

Country	SIT
INDIA	16
INDONESIA	7
JAPAN	6
KOREA	6
MALAYSIA WEST	5
NEW ZEALAND	8
PHILIPPINES	5
TAIWAN	6
THAILAND	6
VIETNAM	7

Re: max function in chart is ignoring dimension

sunny_talwar — Mon, 03 Oct 2016 20:53:19 GMT

Didn't Stefan already help you on this?

Max function as variable in chart ignoring dimension

topic max function in chart is ignoring dimension in QlikView

max function in chart is ignoring dimension

Re: max function in chart is ignoring dimension