topic Re: QlikSense UI formula in App Development

QlikSense UI formula

oanalung — Mon, 30 May 2022 17:09:20 GMT

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

Re: QlikSense UI formula

Clever_Anjos — Mon, 30 May 2022 18:23:12 GMT

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

Re: QlikSense UI formula

MarcoWedel — Mon, 30 May 2022 20:52:30 GMT

maybe also helpful:

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