topic pivot table calculation in QlikView

pivot table calculation

Wed, 08 Feb 2012 10:27:49 GMT

Hi all,

I wrote the if condition in pivot table with one dimension.

the value showing in pivot chart is correct.

but when i add another dimension like sub category the value getting changed.

is there anyway to avoid this problem.

PFA.

thanks in advance.

jagan — Wed, 08 Feb 2012 10:49:09 GMT

Hi,

Please check the attachment.

Hope this helps you.

Regards,

Jagan.

Wed, 08 Feb 2012 11:08:05 GMT

thanks for ur reply,

i forgot one thing.

only category should contain positive value in one chart and negative in another chart.

but sub category may negative or positive values or both.

ur application show only positive or negative values.

thanks in advance