9 Replies Latest reply: Oct 16, 2014 6:02 AM by Alessandro Saccone RSS

    Hiding pivot table column when drilled down beyond two levels

    Manoj P N S

      I am pretty new to qlikview . I have some confidential information in pivot table like salary which needs to be hidden when drilled down beyond certain level. As you see below when drilled beyond country level, the salary column should be hidden.Is this type of hiding possible. Or if count(# last column) < 5 at row level , then salary column should be hidden. Kindly give suggestion. I already tried conditional expression where sum(HC)<5 but it takes the total count and not count at group level.

       

      Data1.jpg