Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dafnis14
Specialist
Specialist

Comparing periods in line chart

Hi,

I need to compare sales periods for a product, for a sale period that crosses 2 subsequent years, in a line chart.

On the X axis i have the sales date in DD-MMM format.

The Year dimension is no good because it will not show the sales for 2 years in the same line.

How can i define the correct period dimension in order to compare them?

Thanks!

10 Replies
swuehl
MVP
MVP

You can use set analysis in your expression  to filter your date dimension, something like

=Sum({<SalesDate = {">=$(=Date(AddMonths(Today(),-24),'DD-MMM YYYY'))"}>} Sales)

(assuming that you also have year YYYY in your SalesDate field format).

If this doesn't help, then please post a small sample QVW.

HirisH_V7
Master
Master

Hi,

Can you tell your Date Format,It Contains Year or not,

Example: DD/MM/YYYY

Then you can have a expression like this,

Sum({< Date={‘>=$(=MonthStart(Max(Date), -23))<=$(=Date(Max(Date)))’}>} Sales )

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Kushal_Chawda

try

=Sum({<SalesDate = {">=$(=Date(AddMonths(max(SalesDate),-23),'DD-MMM'))"}>} Sales)

dafnis14
Specialist
Specialist
Author

Dear People,

Thanks for your kind help.

The business case are selling flights which can be done in a previous year and in the current year.

So it might be helpful to understand.

In case the user select product from previous years then each sale period would be composed of 2 consecutive years which are joined together.

The customer demands that the display on the X-axis would be DD-MMM, because he wants to see a day to day accumulated sales progress.

The original date is DD/MM/YYYY.


Attached is a simple model to demonstrate the issue.

I would like to see the sale period as one line, instead of two for each year.

Thanks!

swuehl
MVP
MVP

Ok, can you somehow outline / sketch how you want to show your two year period in this kind of chart, then?

Maybe using a hand-made sketch drawing?

dafnis14
Specialist
Specialist
Author

Hi Swuehl,

It would be one line as shown in this chart, but the dates would be in descending order:

for example: November, December (of previous year), and then January, February (of the current year):

http://screencast.com/t/msOZfqfsZJkX

Thanks!

swuehl
MVP
MVP

So you probably just want to use SalesDate as dimension (not your ResvDayMonth field), maybe formatted as DD-MMM, but keeping the underlying numeric value.

Then limit your SalesDate using one of the set expressions shown above.

This should show you the year range across year bounderies, with SalesDate shown in chronologic correct order.

dafnis14
Specialist
Specialist
Author

Hi,

I still can't figure how the second dimension (Year)  would be correctly generated.

As we see, it should be merged to one period (e.g., 2014-2015).

Thanks!

dafnis14
Specialist
Specialist
Author

Hi Swuehl,

I think the solution is to use the year of the flight sold instead of the year from the order date.

This way, each line is drawn correctly:

2016-03-12_1320 - DafnaLe's library

What do you think?