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: 
santhoshkasam09
Contributor III
Contributor III

Show Rolling 12 Months of data in Combo Chart

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

4 Replies
adityaakshaya
Creator III
Creator III

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
Specialist II
Specialist II

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
Contributor III
Contributor III
Author

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