Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QS users,
New to Qlik Sense and need some tips on comparing results to previous year. It's a survey and I need to show the yearly trend. In QlikView we achieved this by using expressions on value labels (on bar charts for example), but the only way I can figure out right now is to show the previous result as a line in a combo chart. This solution is not very good.
Are there any workarounds for using expressions with value labels or perhaps some other charts via extensions which would do the thing?
I attached an example made in QlikView.
Thanks for thinking with me.
Regards,
Martin
for CY
Sum({<FinancialYear=,MonthName=, Quarter=,PostingDate=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>} SaleValue)
For LY
SUM({$< FiscalYear={$(=max(FiscalYear)-1)},YEAR_MONTH=p(YEAR_MONTH_PREVIOUS),[Posting Date]={'<=$(vLMaxDate)'},FinancialYear=,MonthName=>}SaleValue)
where vLMaxDate will be variable which holds value
=date(addyears(max([PostingDate]),-1), 'DD/MM/YYYY')
Hope this helps you
Vikas