Qlik Community

Qlik Sense App Development

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

laxmanqlik
Contributor

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
Honored Contributor III

Re: How to sort the Bar chart to financial year

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
Contributor

Re: How to sort the Bar chart to financial year

thanks for the response Shraddha,

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

shraddha_g
Honored Contributor III

Re: How to sort the Bar chart to financial year

It working at my end.

Can you share sample app?

MVP
MVP

Re: How to sort the Bar chart to financial year

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.