Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
paulyeo11
Valued Contributor II

X Axis should i use year or quarter ?

Hi All

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 ?

Paul

nice chart.png

1 Solution

Accepted Solutions

Re: X Axis should i use year or quarter ?

Right,

You should use YOY logic to compare same period for all years.

Regards,

Kaushik Solanki

3 Replies

Re: X Axis should i use year or quarter ?

Hi,

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

Regards,

Kaushik Solanki

paulyeo11
Valued Contributor II

Re: X Axis should i use year or quarter ?

Hello Sir

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.

Paul Yeo

Director

www.tdstech.com<http://www.tdstech.com>

HP+6285883521036 Indo

Re: X Axis should i use year or quarter ?

Right,

You should use YOY logic to compare same period for all years.

Regards,

Kaushik Solanki