Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have field like yearmonth, Year,Month and Sales. i want to show in line chart as Current Year Current Month sales Vs Last Year Same Month sales.
when i selecting specific yearmonth value, it's showing only for currentyear month value. how can we get last year value as well same time.
if i selecting year and month filter separate then its working, but user need yearmonth filter selection.
pls help.
pfa , for snipping
I think the best way to do it it is with the separated filters (year ad month), but if the user insist...
You could load the same data table 2 times, but in the second (lets name it as "auxiliary"), when you upload the date, put this sentence:
Last_year_sales:
load Sales as [Sales last year],
Date_sales+365 as [Date of last year sales]
And in the chart, create 2 expressions, one with sum(sales) and another with sum([Sales last year].
If you don't want to have a ugly chart, you can conditionate the second expression (to show it just when "year month" is selected if you want.
Best regards!
You can check out the following Design Blog post as well, should provide some further guidance on how to go about things:
https://community.qlik.com/t5/Qlik-Design-Blog/Year-over-Year-Comparisons/ba-p/1462927
Regards,
Brett