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

Ignoring dimension with set clause

Hello,

I'm trying to create a table that looks something like this

table-example.jpg

I'm having trouble on creating the "Year total" expression. This should be the sum of "Sales" with only "Product" as filtering variable. When I try to do this with set clause it also uses "Quarter", giving the sum for the "Quarter", not the whole dataset. Here's my set clause

= Sum({$<Year={Year(Quarter)},Quarter=>})

Any help on how to achieve something like this?

1 Reply
Anonymous
Not applicable
Author

You can use the TOTAL keyword as follows:

sum(TOTAL <Product> Sales)

Jonathan