topic Re: Slider in QlikView

Slider

Tue, 25 Feb 2014 12:33:30 GMT

Hi all,

I got a pivot table containing the following information:

revenue revenue ex %

Divisionname+Week

Now I would like to make slider that selects the number of weeks i want the table to show me. When I slide it to the number 7 it shows me 7 weeks. Do I need to put a variable in my dimension?

weeks revenue revenue ex %

Divsion 1 -1

-2

etc

Division 2 -1

-2

etc

kind regards

Re: Slider

Tue, 25 Feb 2014 12:44:30 GMT

In your Slider Properties, under Field, choose Expression, and then type [weeks]

Lucas

Re: Slider

sundarakumar — Tue, 25 Feb 2014 12:44:47 GMT

I think u need to define a calculated dimension for week in the pivot table like,

if(weekno<vSlider,weekno,null())

then select the calculated dimension and check suppress null values

create a slider object and variable called vSilder to complete the process..

-Sundar

Re: Slider

Tue, 25 Feb 2014 12:50:26 GMT

thanks for the quick response!

Re: Slider

sundarakumar — Tue, 25 Feb 2014 12:51:35 GMT

You are welcome