Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

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

Re: How to change my SET analysis to become accumulated ?

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

3 Replies
paulyeo11
Valued Contributor II

Re: How to change my SET analysis to become accumulated ?

enclosed my QV Doc

Re: How to change my SET analysis to become accumulated ?

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
Valued Contributor II

Re: How to change my SET analysis to become accumulated ?

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

Community Browser