Sort issue with Group object using IF(MATCH()..) condition

[shyamcharan]

Hi Experts,

I have a group object created with two fields. One field uses IF(MATCH()..) condition to filter out records and the other is normal field.

When I try to sort the chart x-axis(which uses the group object) in Financial Year-Month order,i.e jul Aug Sep Oct .... May June, but it does not work.

I have used an expression to get the values like 201401,201402..201501,201502..201601,201602 etc.

Please find the attached QVW. Can any suggest what I am missing?

[tyagishaila]

It is working fine.

[shyamcharan]

Thanks Sunny. But I need to sort in Financial YEar order.

like Jul, Aug Sept....May June.

[shyamcharan]

Thanks tyagishaila I need a Financial YEar sort instead not the Cal year sort.

[sunny_talwar · Accepted solution]

Then try this;

Pick(Month(Date#(Cal_Month_Name, 'MMM')), 7, 8, 9, 10, 11, 12, 1, 2, 3, 4, 5, 6)

[shyamcharan]

Hi Tatsiana,

Yes  i need to group in dimension. I would have Month and Day of Month in the group and not financial year.

Sorry the earlier one was a mistake.

The users want to compare month and day comparison across all three years. Hence I need the group.

I am able to achieve my requirement as in attached. However this is a sample QVW with all fields in a table.

In my actual Data Model I have Priority Code and Month Abbreviation quite apart to each other.

When I move the IF(Match()..) to load script and use the new column, it works fine.

Please find the attached QVW.

[tyagishaila]

I think You have calculated unnecessary fields.

Share your original qvw in which you have available fields  and excel file.

Exactly, what output you want?

[t_chetirbok]

you can't use abbreviation as dimension, because Jul, Jun, Jan will be sum as J