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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
khadeer
Specialist
Specialist

Expression?

Hi Below expression i declared in variable

sum({$<Month={$(=min(Month))},BA={'XXX'}>}POB)+(RangeSum(sum({<Month={$(=max(Month))},BA={'XXX'}>}Values))

+sum({$<Month={$(=min(Month))},BA={'XXX'}>}POB)

Its working fine for month selection, Year selection n Quarter selection.

But now i got new requirement that i have to show MTD of that variable.

I mean suppose my above expression giving values like

Apr= 200, May= 300, June= 400, July= 100

When i am selecting multiple selections also i am getting correct values means

Apr&May my result is correct= 500,

but my requirement is if selected May i want to show Apr+May instead of selecting both.

Thanks in advance.

0 Replies