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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Inquiry

4.png

I can display data by year by using the following code: '=SUM({<year = {2010} >}amount).' I insert this code as an expression which gives me the year as a column-header. Pretty slick. Is it possible to add an additional level of granularity such as type? I would like to retain the year as a column-header with type A and B below. Thank you in advance for your assistance.

Don the Intern

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Use pivot table

Year,type as dimensions

Sum(amount) as Expression

Drag year and type to the top

Not applicable
Author

You are correct, but that does not really utilize 'set analysis.'