Discussion Board for collaboration related to QlikView App Development.
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.
Hi Jim,
see Attachment.
If You want only =Count Date change '>=' to '=' in Calculated Dimension Customer
Regards,
Antonio
Hi Jim,
see Attachment.
If You want only =Count Date change '>=' to '=' in Calculated Dimension Customer
Regards,
Antonio
Excellent Antonio, thanks for your quick response. Much appreciated
Jim