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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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