Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everybody,
Need ur help....
In the bottom chart of the below attachment I want Quarter 2 i.e. Q2 to be the first bar followed by Q3 and Q4.
It should be in the following order Q2-Q3-Q4-Q1.
Could anyone help me how to achieve that?
Thanks in Advance.....
Thank you all for all your reply...
In sort tab I tried with:
=match(Quarter,'Q2','Q3','Q4','Q1')
And it worked
In the sort tab of your chart:
use sort by expression then write (using obviously your fields)
If(Quarter='Q2', 1, If(Quarter='Q3', 2, If(Quarter='Q4', 3, 4)) )
Let me know
Alexandros
I Tried this..But it's not woking
Fastest way of getting answered is to upload sample, see: Preparing examples for Upload - Reduction and D... | Qlik Community
Can you attach your document?
can you show the definition of Quaters from load script and Sort tab for your chart
I Tried this..But it's not woking
I have already attached the document
You attached an image, but not qlikview app
In Dimention tab I have used this expression:
=
Replace( if(Souce.='Current Month' or
Souce. =Year(AddMonths(MonthEnd(Today()),-3)) & ' Qtr ' & Ceil(month(AddMonths(MonthEnd(Today()),-3))/3)
or
Souce. = Year(AddMonths(MonthEnd(Today()),-6)) & ' Qtr ' & Ceil(month(AddMonths(MonthEnd(Today()),-6))/3) ,
Souce.),'Current Month',Year((MonthEnd(Today()))) & ' Qtr ' & Ceil(month((MonthEnd(Today())))/3))