Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregation and Pivot Tables Query

I have a table which I have already created and lots of set analysis are done into it:

Loan Index

A 55

B 30

C 56

D 50

E 80

How can I actually split the above table into a nicely pivot table:

Index Percentage band Number of entries

0-30 1

31-60 3

61-100 1

Would need to code the percentage band and check the index to ensure they are within the band.

10 Replies
johnw
Champion III
Champion III


felix.gan wrote:The script does not solve the issue that I have got. I still get the numbers accumulated.


The example I gave doesn't accumulate, so your problem lies elsewhere. As Trent said, perhaps you have accumulation turned on. Properties -> Expressions -> Accumulation. It should be "No Accumulation". You could also be accumulating with the expression, like if you're doing some sort of rangesum() with above(). Don't do that. Or maybe you have a data model that forces accumulation, which is a trick I sometimes employ in examples. Don't do that either. But basicaly, you actually have to do something in order to get accumulation. Accumulation isn't the default. So you did something you shouldn't have done.