topic Re: Conditional expressions in pivot table changing the view of pivot table in QlikView

Conditional expressions in pivot table changing the view of pivot table

Fri, 09 May 2014 10:55:18 GMT

Hello,

maybe can anyone help me I am having a problem with a pivot table. I have conditional view for expresions. There are 3 expresions Sales qty, Buffer, Stock. As you see in the picture 1.

When I choose all of them it's ok, when i choose 2 of them it's ok:

but when i choose 1, the pivot table is changing:

Maybe anyone had the same issue?

Re: Conditional expressions in pivot table changing the view of pivot table

sudeepkm — Fri, 09 May 2014 11:01:15 GMT

can you please mention the condition you applied on the chart expressions.

I think it could be due the condition why it is showing this way. Please post your qvw if possible.

Re: Conditional expressions in pivot table changing the view of pivot table

Fri, 09 May 2014 11:02:36 GMT

Hi, What is the expression used?

Re: Conditional expressions in pivot table changing the view of pivot table

Fri, 09 May 2014 11:21:04 GMT

hi, the conditions is:

where:

as the Id for sales qty is 1126

Re: Conditional expressions in pivot table changing the view of pivot table

Fri, 09 May 2014 11:24:56 GMT

Hi, e_stock_quantity_end_auto and the other two below

Re: Conditional expressions in pivot table changing the view of pivot table

Fri, 09 May 2014 11:43:04 GMT

I think it could be do Pivot table, because when i choose one expresion, then i have to move the dimension back, to get the previuos result with one expression. I don't know why...