Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Using a Slider to select from a Pivot table

Hello

I’ve got a pivot table which contains Customer and Order Date as Dimensions and Product and Cost as Dimensions. I want to be able to use a slider to filter the pivot based on the number of occasions the Customer appears. So for example if 6 is selected on the slider, all Customers who have an entry with 6 dates will be displayed.

Is anyone able to help – or offer an alternative to using a pivot to achieve the above?

Thanks in anticipation.

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: Using a Slider to select from a Pivot table

Hi Jim,

see Attachment.

If You want only =Count Date change '>=' to '=' in Calculated Dimension Customer

Regards,

Antonio

View solution in original post

2 Replies
antoniotiman
Honored Contributor III

Re: Using a Slider to select from a Pivot table

Hi Jim,

see Attachment.

If You want only =Count Date change '>=' to '=' in Calculated Dimension Customer

Regards,

Antonio

View solution in original post

Not applicable

Re: Using a Slider to select from a Pivot table

Excellent Antonio, thanks for your quick response. Much appreciated

Jim