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

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