Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jm1
Contributor
Contributor

column dimension in a table

Hi all,

I need to get a pivot table view without using a pivot table (due to the limited formatting options). What I am trying to do is show the following, where Account/Group and Company are separate dimensions:

 GroupCompany  
AccountG1C1C2C3
11005590
210 10 
3120206040
450102020
560101535
680402020
755  

 

The Group amount = C1 + C2 + C3. There are multiple Groups with different number of companies in each Group. I want the user to be able to select a Group and then it shows the breakdown of that Group next to it, but I dont know how I can achieve this in set analysis.

Does anyone have any ideas how I can achieve this without using a pivot table or drilldown dimensions?

thanks

Labels (4)
1 Reply
jm1
Contributor
Contributor
Author

Hi All,

Any suggestions would be greatly appreciated?

Thanks