How do I filter the entries in a QlikView pivot table depending on a condition ?

Posted on 2014-09-02
Last Modified: 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 ?

Question by:Tocogroup
    LVL 42

    Accepted Solution

    you need to use a calculated dimension instead of SalesPerson


    Then suppress null on the dimension
    LVL 42

    Expert Comment

    by:Rob Jurd, EE MVE

    =if(MixMatch(Sales_Location, 'West Coast', 'Australia', 'New Zealand'), SalesPerson)

    Author Closing Comment

    Thanks Rob. That works great !
    LVL 42

    Expert Comment

    by:Rob Jurd, EE MVE
    No problem.  I don't see many Qlikview questions so keep them coming :)

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
    Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
    This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
    The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now