Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
oanalung
Contributor III
Contributor III

QlikSense UI formula

hi, I have this formula - sum([Sales]) that I am using in a chart. 

is there a way to write this formula so that only one field can be used to  change the data in the chart(to filter) - Month? 

I want to make sure sums are always shown the same no matter what selections we have in the app, but I want to change the chart only based on Month filter. 

 

thank you

Labels (1)
2 Replies
Clever_Anjos
Employee
Employee

Please try with
sum({1<Month=P(Month)>}[Sales])

MarcoWedel

maybe also helpful:

Sum({1<Month=$::Month>} Sales)