Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Conditional expressions in pivot table changing the view of pivot table

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.

pivot.jpg

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

2chosen.jpg

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

1chosen.jpg

Maybe anyone had the same issue?

5 Replies
sudeepkm
Valued Contributor III

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

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.

Not applicable

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

Hi, What is the expression used?

Not applicable

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

hi, the conditions is:

properties.jpg

where:

condition.jpg

as the Id for sales qty is 1126

Not applicable

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

Hi, e_stock_quantity_end_auto and the other two below

condition.jpg

Not applicable

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

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

changing.jpg

Community Browser