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: 
Mario1011
Contributor
Contributor

help with set analysis....

I need my graph to ALWAYS display the full year by month, irrespective of the month selected - where would I insert the {1} in the following expression?

sum({$<Type={'Budget'}>}Amount)

2 Solutions

Accepted Solutions
Lisa_P
Employee
Employee

Replace the $ with a 1

sum({1<Type={'Budget'}>}Amount)

View solution in original post

Vegar
MVP
MVP

If it is only the month you want to disregard then you can skip the {1}, and instead pinpoint the month field like this: 

sum({$<Month=, Type={'Budget'}>}Amount)

View solution in original post

2 Replies
Lisa_P
Employee
Employee

Replace the $ with a 1

sum({1<Type={'Budget'}>}Amount)

Vegar
MVP
MVP

If it is only the month you want to disregard then you can skip the {1}, and instead pinpoint the month field like this: 

sum({$<Month=, Type={'Budget'}>}Amount)