Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
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.
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), ......
I created variables using below expression:
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!!
may be this can help u