Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot - aggr

Udklip.PNG.pngHi there

Is it possible to get the aggr( count), År) on every field where the expression match dimension ÅR.

ex every field with 2011 as dimension will contain 132...

Looking forward to hear your suggestions

Thanks

/Teis

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Use count(total <År> Svar)


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

Hi,

Have you tried Properties>>Presentation>>> Show Partial Sum

Gysbert_Wassenaar

Use count(total <År> Svar)


talk is cheap, supply exceeds demand
Not applicable
Author

Hi,

Show Partial Sum, will not get the job done, I need the total for dimension År in every field it match

thanks for the reply Jonathan

Not applicable
Author

Thanks  a lot Gysbert

Do u know where I can find the definition on <> in a statement ?

Gysbert_Wassenaar

In the help file. Look up the Chart Aggregation Functions entry.


talk is cheap, supply exceeds demand