Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stuhico09
Contributor

Chart clustering by month

Hi Guys,

Is there any way to cluster the bar chart by month ? I want to make the jan 2015 & jan 2016 side by side.

Then, between jan 2016 & feb 2015, there should be gap as it is different month. Kindly help. Thanks.

xxx.PNG

2 Replies
elena_isupova
New Contributor III

Re: Chart clustering by month

!Hi Ahmad,

If you generate a field with MonthYear together and put it as dimension to your barchart then it will work (of course sorting by monthyear). Use the atteched file.

HIH

Elena

gferran
New Contributor III

Re: Chart clustering by month

Hi Ahmad,

a simple way to do this is creating two measures:

- Sum({$<Year={2014}>}Value)

- Sum({$<Year={2015}>}Value)

with a unique dimension: month

I have used the Elena's file to apply the modifications.