7 Replies Latest reply: Aug 25, 2017 1:15 AM by anya K. RSS

    Function P() or E()

    Matheus Colares

      Hi

           I have a pivot table with two dimension:

       

                          State  |       State1     State2     State3

      Product                  |     

             product1                      -               3           4

             product2                      1               6           5


      What i want?...Filtrer product1 and qlik show me this:

                         

                          State  |       State1     State2     State3

      Product                  |     

             product1                      -               3           4

       

      and not this;

       

                          State  |         State2     State3

      Product                  |     

             product1                         3           4

       

      I mean, i want it to appear all states having data or not. Because a need know what product not have sales in any states.

       

      obs: a select option "Show null values", but not work"

       

      I'm tried use P() function, like this:

       

      sum({< State = P(State)>} sales) , but not work...=/