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: 
laxmanqlik
Creator II
Creator II

How to sort the Bar chart to financial year

i have a bar chart with revenu and month fields,

now  i have to show the revenue of the financial year i.e, the dimension means month should start from April and has to end on March

please suggest me a way to solve.

thanks in advance...

4 Replies
shraddha_g
Partner - Master III
Partner - Master III

In Sort by Expression try:

Pick(wildmatch(Month,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar'),

1,2,3,4,5,6,7,8,9,10,11,12)

laxmanqlik
Creator II
Creator II
Author

thanks for the response Shraddha,

but its not working, it showing from May to march...

shraddha_g
Partner - Master III
Partner - Master III

It working at my end.

Can you share sample app?

jonathandienst
Partner - Champion III
Partner - Champion III

There are plenty of examples here of how to correctly set up and perform fiscal period analysis using a master calendar. Search this site for master calendar and fiscal/financial periods and you should find a solution that works for you.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein