How do I filter the entries in a QlikView pivot table depending on a condition ?
Posted on 2014-09-02
I have a QlikView dashboard displaying a pivot table with a vertical dimension (Product name) and a horizontal dimension (Salesperson). The pivot table measures the number of sales (a COUNT) against each salesperson.
However, the pivot table displays ALL the sales people across the top of the table, whereas, I want to only display those sales people that meet a specific criteria (a field called Sales_Location).
How do I do this ?