Show Rolling 12 Months of data in Combo Chart

[santhoshkasam09]

Hi All,

I have the below requirement:

Based on the selection of Month and Year, in the Combo graph, Bar chart should show the data from last 12 months i.e., if selection is Apr 2018, the it should show the data from May 2017 to Apr 2018.

And Line should show the data from May 2016 to Apr 2017. Please suggest me in completing the requirement.

Thank you.

Regards

Santhosh Kasam

[adityaakshaya]

Hi Santhosh,

As per my understanding, you can't have bar chart and line chart on different points in a same combo chart.

For example, you can have time at your x axis and can add two expressions or measures at y axis.

Regards,

Akshaya

[ogautier62]

Hi,

may be try using valueloop :

in dimension valueloop(1,12)  for 12 months

and 2 expression with

sum(  if(month>=max(Month) -12, 'field') )

and sum( month>=max(Month) -24 & month<max(Month -12), ......

regards

[santhoshkasam09]

Hi Olivier,

I created variables using below expression:

vCurrMaxPeriod: Date(Monthend(Max(Period)))

vCurrMinPeriod: Date(Monthstart(addmonths(Max(Period),-11)))

Now I am using set analysis restrict the count but the I am not able to restrict the count. I think it is due to mismatch in the data type. Please help me in resolving the issue.

Thanks in advance!!

Regards

Santhosh Kasam

[manoranjan_d]

https://community.qlik.com/t5/Qlik-Sense-App-Development/Month-Vs-Rollign-12-months-in-combo-chart/m...

may be this can help u