Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

matheus_silva
Contributor

Function P() or E()

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

 

7 Replies

Re: Function P() or E()

State1 , 2 and 3 are expression ??

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

matheus_silva
Contributor

Re: Function P() or E()

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.

Re: Function P() or E()

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

matheus_silva
Contributor

Re: Function P() or E()

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

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

Re: Function P() or E()

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

ahaahaaha
Honored Contributor

Re: Function P() or E()

Hi Matheus,

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

Regards,

Andrey

inoruoya
New Contributor II

Re: Function P() or E()

try this

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

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