Limit value in pivot table according to variable?

[#1]

Dear All,

I have read many topic related to limit value, however, there is no precise answer for my case.

I attach the qlik file for easier view.

Please help

Many thanks

Dong

[Anil_Babu_Samineni]

What do you mean Limit Value, Can i know more input issues from your end, Bcz i don't have license

[Anonymous · Accepted solution]

Hi Dong,

Create a variable called vRDL_Dim with this expression:

=If(vRSL='All','>-9999',vRSL)

Change batch dim with a calculated dim with this expression:

=IF(([Expiry Date]-vDate)/30$(vRSL_Dim), Batch)

Select Suppress When Value Is Null on this dimension.

Regards!!

[#4]

I have 3 dimensions: description, Batch, Expiry Date; and 3 expressions are RSL, RSL text, Qty where:

* RSL = ([Expiry Date]-vDate)/30 (vDate is variable which value is given by Calendar object)

* RSL text = if(RSL<=6,'<=6',if(RSL<=9,'<=9',if(RSL<=12,'<=12','>12')))

* Qty = sum([Stock Total])

vRSL is variable which has value from input box. It is constrained by listed value with formula =Concat(DISTINCT Shelflife,',')

And Shelflife is create by below scripts

LOAD * INLINE [
Shelflife
All
>12
<=12
<=9
<=6
];

And in "Show value" under RSL text expression, I put the formula  [RSL text]=vRSL

but it doesn't work when I choose any value in input box whether it is <=6, <=9, <=12, >12, or All.

The idea is that the pivot table will show only records matching between RSL text and Shelflife

Description	Batch	Expiry Date	RSL	RSL text	Qty
Product A	5SF37	2/1/2017	3.7	<=6	0
Product A	5SF43	2/1/2017	3.7	<=6	7
Product A	5SJ27	5/1/2017	6.7	<=9	2129
Product A	5SK61	6/1/2017	7.7	<=9	0
Product A	5SN13	8/1/2017	9.7	<=12	0
Product A	5SV24	9/1/2017	10.8	<=12	0
Product A	5SV25	9/1/2017	10.8	<=12	0
Product A	5SV45	10/1/2017	11.8	<=12	0
Product A	6S088	12/1/2017	13.8	>12	3973
Product A	6S779	2/1/2018	15.9	>12	34065
Product A	6S800	2/1/2018	15.9	>12	37613
Product A	6S940	3/1/2018	16.8	>12	118069
Product A	6S995	3/1/2018	16.8	>12	24554

[#5]

Thanks so much