topic Re: Current selection plus the last 6 months in Line Chart in QlikView

Current selection plus the last 6 months in Line Chart

0li5a3a — Thu, 22 Jun 2017 15:30:28 GMT

Hi all,

I need to create a Line Chart where I would like to show the current selection and the last months too.

COUNT({$<aaa= {'xxx',''}>} aaa) i used this for the current selection but I would like to display the data for the last 6 months too.

Is this possible in set analysis?

Kind regards,

Constantin

Re: Current selection plus the last 6 months in Line Chart

Anil_Babu_Samineni — Thu, 22 Jun 2017 15:38:04 GMT

May be this? I assume, You have Neat Date Format

COUNT({$<aaa= {'xxx',''}, DateField = {">= $(=Date(AddMonths(Max(DateField),-6))) <=$(=Date(Max(DateField)))"}>} aaa)

Re: Current selection plus the last 6 months in Line Chart

Anonymous — Thu, 22 Jun 2017 15:53:30 GMT

Can you provide more info or some sample data?

Is the current selection also the date? So you want all date from the currently selected date back 6 months?

Or some other dimension? If some other dimension do you want that selection PLUS the last 6 months ignoring the selection?

Re: Current selection plus the last 6 months in Line Chart

0li5a3a — Thu, 22 Jun 2017 20:30:46 GMT

Hi,

The current selection are year and months.

I want to select them and after my line chart to show me the selection like year 2017 and month june plus 6 previews months.

Thank you

Re: Current selection plus the last 6 months in Line Chart

Anonymous — Thu, 22 Jun 2017 20:37:44 GMT

Then I think you need something very similar to what Anil provided. Assuming you have a DateField too.

Something like:

COUNT({$<YourYearField=,YourMonthField=, DateField = {">= $(=Date(AddMonths(Max(DateField),-6))) <=$(=Date(Max(DateField)))"}>} aaa)

Re: Current selection plus the last 6 months in Line Chart

0li5a3a — Fri, 23 Jun 2017 09:34:33 GMT

using the above code I achieved this, which is wrong

Re: Current selection plus the last 6 months in Line Chart

0li5a3a — Fri, 23 Jun 2017 09:45:53 GMT

Thank for your answer but the above code doesn't work for me..

I created 2 columns like:

monthname(OrderDate) as CalendarPeriod

num(MonthName([OrderDate)) AS CalendarPeriodnum

plus I added this code to my expression :

count({$<aaa= {'xxx',''}, CalendarPeriodnum={'>= $(=num(MonthStart(AddMonths(max(CalendarPeriod),-5)))) <= $(=num(MonthEnd(max(CalendarPeriod))))'},D_InvCal.CalendarMonth=,D_InvCal.CalendarYear=>}aaa)

The problem is if I select year 2017 the data in line chart is not organised in the right position.

Please check below.

Re: Current selection plus the last 6 months in Line Chart

0li5a3a — Fri, 23 Jun 2017 10:01:50 GMT

Thank you all for your help. I managed to fix the problem. I changed the dimension to be monthyear and now all is ok.