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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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)