Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
snehamahaveer
Creator
Creator

Overlay 2 rolling 12 month charts in one

Hi All,

My latest requirement is to create a chart that shows two rolling 12 month as a comparison of one another.

I am able to show them separately as 24 month period. However, when I overlay them by month as dimension I am unable to sort them based on the latest month values. The chart automatically sorts from Jan - Dec or Dec-Jan and not by the latest month to the last 12 months.

Can someone please help with this

Thanks in advance.!

1 Solution

Accepted Solutions
sunny_talwar

Try this

=Num(Month(Date#(Only({1} Month), 'MMM'))) - Num(Month(Date#(Only(TOTAL Month), 'MMM'))) + 1 +

If(Num(Month(Date#(Only({1} Month), 'MMM'))) - Num(Month(Date#(Only(TOTAL Month), 'MMM'))) + 1 <= 0, 12, 0)

Capture.PNG

View solution in original post

23 Replies
Anil_Babu_Samineni

I assume, You applied 12 moths roll-out expression to Bar one not the Symbol one. Can you apply the same set analysis for 2 metrics then check. If not, I would ask you to share mock up application

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

How are you sorting your symbol chart? I am guessing that's the one which is not working, right?

snehamahaveer
Creator
Creator
Author

Hi Sunny,

I am only able to sort based on month(dimension) and not on expressions. Currently I tried by Month no, Month, or by expression as well. However, I am not able to sort it the based on the latest month.

Kind regards,

Sneha

sunny_talwar

Would you be able to share a sample for us to take a look at?

RonaldDoes
Partner
Partner

Hi Sneha,

If you sort your months according to an expression, and enter

=If(Month(Date)<6, Month(Date)+12, Month(Date))

that would have your month order running from june to may.

Please find an attached example. Does this solve your problem?

Naamloos.png

With kind regards,

Ronald

snehamahaveer
Creator
Creator
Author

Hi Guys,

Thanks for your responses. However, please find attached a test version of the same.

Any help is much appreciated.

Thanks

Apologies - I have changed the expression to the correct one.

marcus_malinow
Specialist III
Specialist III

Hi Sneha,

use the Sort by Expression option. Expression for this should be max(Date)

Marcus

snehamahaveer
Creator
Creator
Author

Thank you Ronald,

This would work when a single 12 rolling month expression is written. Also, I want the sort to be dynamic based on the latest selection made. I have attached a test app - please let me know if you can solve my dilemma

snehamahaveer
Creator
Creator
Author

Hi Marcus,

When I use max date, it sorts the latest month first. However - its followed by January? Not sure if its supposed to do that.