Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hamza99a
Contributor

add field to existing dimension

hello qlik community. I currently have a pivot table showing my three separate regions, Central Southern and Other. It shows the balances for each region and the account types for each region. What I would like to do is to add another dimension or measure called Total that would essentially sum all balances for each region and show me each account type's total balance. I understand there is a totals function, but I need it to display at the bottom. I also understand in the straight table it shows the totals on the bottom, however I also need partial totals for each region. Any help would be appreciated!

1 Solution

Accepted Solutions

Re: add field to existing dimension

Is this what you want?

Capture.PNG

11 Replies
hamza99a
Contributor

Re: add field to existing dimension

Re: add field to existing dimension

May be share a sample and provide an Excel mock up for your expected output based on the sample provided

hamza99a
Contributor

Re: add field to existing dimension

stalwar.PNG

under south I want it to show

- Total                                                            3364797

Business                                                       sum(business)

Government Account                                    sum(Gov't Account etc.

Personal

Thank you! This screenshot is cutting out some of our numbers as this is sample data. But I hope you can understand what I am trying to do here.

Thanks for the reply!

Re: add field to existing dimension

Would you be able to share the above qvf to show you how this can be done?

hamza99a
Contributor

Re: add field to existing dimension

unfortunately, it has sensitive data so I will have to see if I could create a sample data set. is there any way to simply add another field to region in the app overview?

Re: add field to existing dimension

All, I am looking for a mock up data... I don't care about the numbers... all I care is to see how the data is structured and how the chart is created

hamza99a
Contributor

Re: add field to existing dimension

This is some sample data. Thanks

Re: add field to existing dimension

Is this what you want?

Capture.PNG

hamza99a
Contributor

Re: add field to existing dimension

YES!

Community Browser