topic Function P() or E() in QlikView

Function P() or E()

Anonymous — Thu, 23 Feb 2017 14:13:54 GMT

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 — Thu, 23 Feb 2017 14:21:30 GMT

State1 , 2 and 3 are expression ??

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

Anonymous — Thu, 23 Feb 2017 14:31:12 GMT

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 — Thu, 23 Feb 2017 14:36:50 GMT

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

Anonymous — Thu, 23 Feb 2017 16:18:04 GMT

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

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

avinashelite — Fri, 24 Feb 2017 07:14:23 GMT

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

ahaahaaha — Fri, 24 Feb 2017 07:46:27 GMT

Hi Matheus,

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

Regards,

Andrey

inoruoya — Fri, 25 Aug 2017 05:15:14 GMT

try this

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

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