Skip to main content

App Development

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

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 (2)
1 Reply
jm1
Contributor
Contributor
Author

Hi All,

Any suggestions would be greatly appreciated?

Thanks