Qlik Community

Qlik Sense App Development

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted
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

Highlighted
Contributor III
Contributor III

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

Highlighted