Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You have to bypass YEAR_MONTH filter in your expression...
what is your expression in expression tab?
=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))
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
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
this is the data in Table :