Function P() or E()

[Anonymous]

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...=/

[avinashelite]

State1 , 2 and 3 are expression ??

Then you need to conditional hide the expression when they are null

[Anonymous]

State1,2,3 are fields...expression are  -,3,4 which is sum(sales).

What i want, for example is, even State1 not have sales, i want see when i filter it.

[avinashelite]

Go to Presentation tab > and Un-Check suppress null value and missing Values that should work

[Anonymous]

I forgot to say, i'm working with qlik sense...

But i'm tried this to...=/

[avinashelite]

Oh , then please close this thread hear and open an new one under the Qliksense category

[ahaahaaha]

Hi Matheus,

As far as I know, such settings for your task in Qlik Sense no.

Regards,

Andrey

[inoruoya]

try this

sum({< State=P({<Product=}>}State) >} sales)

I think you mean possible state that any product have  right?