topic Using a Slider to select from a Pivot table in QlikView

Using a Slider to select from a Pivot table

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Using a Slider to select from a Pivot table

antoniotiman — Sat, 19 Nov 2016 09:20:54 GMT

Hi Jim,

see Attachment.

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

Regards,

Antonio

Re: Using a Slider to select from a Pivot table

Sat, 19 Nov 2016 11:36:13 GMT

Excellent Antonio, thanks for your quick response. Much appreciated

Jim