topic Re: 12 months Trend for Max Transaction in QlikView

12 months Trend for Max Transaction

d4rlie891 — Thu, 23 Jun 2016 09:18:43 GMT

Hello everybody,

I have a problem, why my 12 months Trend Line only show 1 month value when I select a Year_month in QlikSense?

This is my Measure : Max(Aggr(sum({$<YEAR_MONTH_W = {">=$(=date(addmonths(max(YEAR_MONTH_W), -12), 'YYYY-MM'))"} * {"<=$(=max(YEAR_MONTH_W))"}>}TOT_TRANS),TANGGAL)).

If I don't select any Year_month, the Trend line is OK.

Best Regards

Dmw

Re: 12 months Trend for Max Transaction

MK_QSL — Thu, 23 Jun 2016 09:25:18 GMT

You have to bypass YEAR_MONTH filter in your expression...

what is your expression in expression tab?

Re: 12 months Trend for Max Transaction

varshavig12 — Thu, 23 Jun 2016 09:36:04 GMT

=Max(Aggr(sum({$<YEAR_MONTH_W = {">=$(=date(addmonths(max(YEAR_MONTH_W), -12), 'YYYY-MM'))"} * {"<=$(=max(YEAR_MONTH_W))", YEAR_MONTH_W=}>}TOT_TRANS),TANGGAL))

Re: 12 months Trend for Max Transaction

d4rlie891 — Thu, 23 Jun 2016 09:51:35 GMT

HI,

I have changed the expression with : Max(Aggr(sum({$<YEAR_MONTH_W = {">=$(=date(addmonths(max(YEAR_MONTH_W), -12), 'YYYY-MM'))"} * {"<=$(=max(YEAR_MONTH_W))", YEAR_MONTH_W}>}TOT_TRANS),TANGGAL))

But the Result is still the same. It only shows 1 month value when I select a Year_month.

Best Regards

Re: 12 months Trend for Max Transaction

d4rlie891 — Thu, 23 Jun 2016 09:57:39 GMT

Hi,

Sorry, what do you mean with Expression in expression tab ?

the expression for the the trend line chart is :

Max(Aggr(sum({$<YEAR_MONTH_W = {">=$(=date(addmonths(max(YEAR_MONTH_W), -12), 'YYYY-MM'))"} * {"<=$(=max(YEAR_MONTH_W))"}>}TOT_TRANS),TANGGAL))

I have tries to bypass the YEAR_MONTH, but the result is still the same.

Max(Aggr(sum({$<YEAR_MONTH_W = {">=$(=date(addmonths(max(YEAR_MONTH_W), -12), 'YYYY-MM'))"} * {"<=$(=max(YEAR_MONTH_W))", YEAR_MONTH_W}>}TOT_TRANS),TANGGAL))

Thanks

Re: 12 months Trend for Max Transaction

d4rlie891 — Fri, 24 Jun 2016 00:58:08 GMT

this is the data in Table :