Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total Aggrupation on same expression

Hello,

I was wondering if you guys have any idea how i could represent different groups of Data by grouping the same expression.

For example:

I got a table that has the account number and the value on the account.

My current table shows information on different levels (pivot table), and has one expression, that the sum(Value).

This way, when u drill down you get to the account and the value.

I need to group like a range of accounts and show the total of that account, and then another range of accounts with another total, but not in different expresions so i dont have a lot of zeros on the accounts that are not grouped on each expression.

(Table of example)

Currently at the end of the pivot table it looks like:

AccValue
111
121
131
211
221
231
311

I want to have:

AccValue
114
125
131
Total 1's10
213
221
232
Total 2's6
311
Total 3's1
Grand Total17

Is there anyway of doing this?

Am I explaining my self correctly?

thanks in advance,

1 Solution

Accepted Solutions
kamalqlik
Partner - Specialist
Partner - Specialist

HI Mariana,

Attached is the application with solution of your query.

Regards,

Kamal

View solution in original post

4 Replies
Gysbert_Wassenaar

Perhaps you can simply create an extra field in the script, i.e. left(Acc,1) as Group, and add that new field as dimension to your pivot table. Or perhaps you want to create something like the P&L statement as described in this blog post: How IntervalMatch Solved My Profit and Loss Dilemma


talk is cheap, supply exceeds demand
petter
Partner - Champion III
Partner - Champion III

Like this?

2015-09-11 #2.PNG

kamalqlik
Partner - Specialist
Partner - Specialist

HI Mariana,

Attached is the application with solution of your query.

Regards,

Kamal

Not applicable
Author

thanks this solved it perfectly.

the other solutions where a little more difficult to implement with my data model, thats why i mark you correct answer, but thanks to everyone.

KR