topic Re: Displaying data based on slider in QlikView

Displaying data based on slider

Wed, 20 Nov 2013 09:15:38 GMT

I had a slider based on days.(eg: 30,60....).

I have 'Days' column in pivot table.Based on the selection of slider, data should be changed accordingly. But it is not showing.

Eg: Suppose if I select 30 days in slider, data till 30 days should be shown.If I select 60 data till 60 days should be shown.

I created a variable on days for slider.

Can anyone reply soon.

Re: Displaying data based on slider

Wed, 20 Nov 2013 09:30:35 GMT

Hi,

For this you have to put condition according to your variable which you created for slider in pivot table expression tab. I think you want to get record for latest 30 or 60 days. So using set analysis, put condition in expression according to variable value.

For better clarification, attach sample file here.

Regards,

Ashutosh

Re: Displaying data based on slider

bbi_mba_76 — Wed, 20 Nov 2013 09:31:29 GMT

Hi,

you have to change the expressions in your tables to filter data using the variable set with the slider.

Re: Displaying data based on slider

Wed, 20 Nov 2013 09:32:41 GMT

Hi Sahithya

This can be done quite easily - at least once you know how to write the formula. Can you send me the name of your variable and the formula you are using and I'll try to amend it to ensure it works?

Regards

Steve

Re: Displaying data based on slider

Wed, 20 Nov 2013 10:14:02 GMT

Got the solution by creating 2 variables,rangestart and rangeend of slider.

Thanks for all your replies.