Using Slider to change the Value in the Expression

rabbani_sk — Fri, 23 Aug 2013 05:40:05 GMT

Hi all ,

I need to use a slider which consists of 15 days ,

by selecting the no. of days on the slider, it should dynamically add the same number of days to the Promise date.. which i am using in the expression .

the expression i used is as below,

=if(Bill.Qty>Order.Qty and Bill.Date>Promise Date, Count(S.Ord.No))

This is my expression in the pivot table, so i need to add a slider which consists of 15 days , (i.e Delay Days)

If i select the no. of Delay days on the Slider , that many days should be dynamicalluy added to the Promise date in the expression , is thios Possible are not??

Re: Using Slider to change the Value in the Expression

whiteline — Sat, 24 Aug 2013 19:17:12 GMT

Hi.

Create a slider for a new variable instead of particular field.

Set the appropriate min and max values (1 and 15 in your case as I think).

Then modify your formula to add the variable value to the Promise Date.

topic Using Slider to change the Value in the Expression in QlikView

Using Slider to change the Value in the Expression

Re: Using Slider to change the Value in the Expression