Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ferha_jafri
Not applicable

Issue with calculated dimension in pivot table

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

1 Solution

Accepted Solutions
mayilvahanan
Not applicable

Re: Issue with calculated dimension in pivot table

Hi

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

5 Replies
ariel_klien
Not applicable

Re: Issue with calculated dimension in pivot table

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.

BR

Ariel

ferha_jafri
Not applicable

Re: Issue with calculated dimension in pivot table

Hello,

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

mayilvahanan
Not applicable

Re: Issue with calculated dimension in pivot table

Hi

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

nizamsha
Not applicable

Re: Issue with calculated dimension in pivot table

please attach some samples

ferha_jafri
Not applicable

Re: Issue with calculated dimension in pivot table

Thank you so much