Discussion board where members can learn more about Qlik Sense App Development and Usage.
I like to create the below using QS , my issue is for the below image they using Year for X axis .
I try to using year for Axis , but my issue is my sales data is not complete , it only have sales from Jan till 7 Sept.
If i using Year , it is not a fair compare with previous year. as LY have full year sales value and for 2016 only have Jan sales till Sept.
Hope some one can advise me my X Axis should i using Quarter ?
Go to Solution.
You should use YOY logic to compare same period for all years.
Its a business call, whether you want to see the Year or Quarter.
In Both the cases you may need the Set Analysis in Expression to get correct comparison.
Have a look at the below link for more help.
Set Analysis for certain Point in Time
Thank you for sharing the link to me which have very useful SET expression .
Now my issue is on the Bar chart if I use by year is not correct , because the rest of bar is full year .
If I using the month is correct but I unable see the last 3 year trend. Same for quarter.
May be I will using YOY , so that I can compare all bar with same period. That is Jan till Sept.