Need Help Urgent....

[#1]

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.....

[alexandros17]

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

[#3]

I Tried this..But it's not woking

[tresesco]

Fastest way of getting answered is to upload sample, see: Preparing examples for Upload - Reduction and D... | Qlik Community

[alexandros17]

Can you attach your document?

[SergeyMak]

can you show the definition of Quaters from load script and Sort tab for your chart

[#7]

I Tried this..But it's not woking

[#8]

I have already attached the document

[SergeyMak]

You attached an image, but not qlikview app

[#10]

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))