6 Replies Latest reply: Jun 10, 2015 4:12 AM by Kiran QlikView RSS

    How to hide rows of pivot table based on condition.

      Hi All,

       

      I have data like below

      I wan to create a pivot table like below when FLAG=1. but this condition I want to use in UI level not in Script level.

      (Because I have other object which needs to have total data)

       

      Resulted - pivot: (Note: here in list box I selected 1 as Flag so that result is correct. but I don't want to do like this. by default Pivot need to be displayed like below without selecting Flag=1 in List Box)

       

      You can check this pic in WORD file plz.

       

       

      I have attached sample data and Qvw file. please help and attach the resulred qvw to the reply.

       

       

      Thanks,

      Kqv