Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master III
Master III

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
Master III
Master III

Hi Jim,

see Attachment.

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

Regards,

Antonio

Not applicable
Author

Excellent Antonio, thanks for your quick response. Much appreciated

Jim