Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to change my SET analysis to become accumulated ?

Hi All

I have SET analysis as beow working fine :-

sum({$<           year=,          month=,           MonthSeqNum = {$(=only(MonthSeqNum)-12),$(=only(MonthSeqNum))} >}  sales/1000)

When i click month = 1 the amt display 546

When i click month = 2 the amt display 826

May i know how to modify the above expression , so that it will behave as below :-

When i click month = 1 the amt display 546

when i click on month = 2 so it display as 546 + 826 = 1372 ?

Paul

1 Solution

Accepted Solutions
marcus_sommer

This couldn't be achieved with the set analysis expression itself you need the above/below functions to accumulate the expression with the other rows, see: Re: Rangesum Above not working.

- Marcus

View solution in original post

3 Replies
paulyeo11
Master
Master
Author

enclosed my QV Doc

marcus_sommer

This couldn't be achieved with the set analysis expression itself you need the above/below functions to accumulate the expression with the other rows, see: Re: Rangesum Above not working.

- Marcus

paulyeo11
Master
Master
Author

Hi Sir

Thank you for your suggestion , and i manage to recall the expression which some one help me 3 year ago  :- .

Diamension Year and ColumnDim

money(

Sum({<IsInYTD={1}, Year={">$(=year(today())-2)"}> } sales/$(Columndim89)/1000)

, $(vMoneyFormatK))

money(

Sum(

{<Year={'>$(=year(today())-2)'}>}

sales/$(Columndim89)/1000)

, $(vMoneyFormatK))

Diamension on yearmonth:-

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} sales/$(Columndim89)/1000)

Thank you.

Paul