Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

Can Sunny SET expression be modify to make it more dynamic ?

Hi All

I have got this SET expression from Mr sunny :-


Money(RangeSum(
Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),
-Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth)))
, $(vMoneyFormatK_GL))

My question is , it is possible to modify to change the above expression to make it more dynamic. So when user not select any date it will display current month and year amount.

If user click on year=2015 , month = march. The above above amount will change to Last year same period amount.

Paul

3 Replies
paulyeo11
Valued Contributor II

Re: Can Sunny SET expression be modify to make it more dynamic ?

my QVF

Re: Can Sunny SET expression be modify to make it more dynamic ?

What would be a expected value when you select 2015 and March?

paulyeo11
Valued Contributor II

Re: Can Sunny SET expression be modify to make it more dynamic ?

Hi Sunny

1.5 million.png

Community Browser