Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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.'