chart x- axis sorting

[#1]

Hi All,

I'm having a chart in attached qlikview file. I want to sort x-axis values as follows

OOC,

1 month,

2 to 3 months

4 to 6 months

>12 months.

I think I have to write some condition under sort tab but I'm not getting which condition to write there.

I tried with sum(bucket), count(bucket). But they are not giving required result. So please help me sort x-axis in the way I have explained above.

Thanks a lot!!!

[alexandros17]

... I think this is a mistake unless you use an aggregation function ...

[#3]

Why?

[alexandros17]

There are multiple rows with same values, when you write bucket which value (and row) satisfy the condition?

[#5]

I agree, this would be ideal.

[#6]

Thanks a lot Jacob

[#7]

Hi Krupasagar ,

Yes this is a better way to do it.

[#8]

No problem homie