topic Re: Issue with calculated dimension in pivot table in QlikView

Issue with calculated dimension in pivot table

ferha_jafri — Tue, 01 Oct 2013 11:33:48 GMT

Hello Everyone,

I need help i have to create a pivot table in whicth the hierarchy is as product name,product grouping,sbu,subdivision,div,zone in this i have to push the zone upwards and have to create 4 expression for current and previous MTD and current and previou YTD my issue is i have to reduce the data fileds in zone dimension as i have 10 zones in total and i want to show 3 zones in the upward direction,please help it is urgent.

Thanks in advance

Ferha Jafri

Re: Issue with calculated dimension in pivot table

ariel_klien — Tue, 01 Oct 2013 11:42:19 GMT

Hi,

in the chart properties there is a tab "Dimension limits" (in QV 11)

you can chose how many row in the dimension you want to show... like Top 3.

hope this will help you.

Ariel

Re: Issue with calculated dimension in pivot table

ferha_jafri — Tue, 01 Oct 2013 11:46:58 GMT

Hello,

No it is not the case as i want to select India ,North and South these particular zones in my pivot table

Re: Issue with calculated dimension in pivot table

MayilVahanan — Tue, 01 Oct 2013 11:49:36 GMT

You can use in expression by using set analysis

= Sum({<Zones = {'India','North','South'}>}Sales)

Use in all the expressions in the chart

Hope tat helps

Re: Issue with calculated dimension in pivot table

nizamsha — Tue, 01 Oct 2013 11:50:12 GMT

please attach some samples

Re: Issue with calculated dimension in pivot table

ferha_jafri — Tue, 01 Oct 2013 12:12:47 GMT

Thank you so much