sorting issue

[rathnam_qv]

Hi All,

I have a bar chart whose dimentions(Jan,Feb...Dec) are sorted using an expression.

At script level i have implemented section access in this report.

My issue is:sorting order of the dimensions is getting chaged for few users and not for all.

This is the Expression i amusing to sort---->Dual("MONTH",match"MONTH" ,'Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep',))

my financial year starts from 'Oct to Sep"

can anyone help me out.

Regards,

Rathnam.

[aveeeeeee7en]

Hi

Try this:

Dual(YourMonthFieldinScript,Match(YourMonthFieldinScript,'Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep'))

or, create an Inline Table and use it for sorting.

Month_Sort_Table:

Load * Inline [

Number, Month

1, Oct

2, Nov

3, Dec

4, Jan

5, Feb

6, Mar

7, Apr

8, May

9, Jun

10, Jul

11, Aug

12, Sep

];

Regards

Av7eN

[perumal_41]

Hi,

is possible to upload sample app.

[amit_saini]

Rathnam,

Like this???

Thanks,

AS

[ashfaq_haseeb]

Hi use this in your sort tab expression.

Dual(Month,match(Month ,'Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep',))

Regards

ASHFAQ

[rathnam_qv]

Hi Perumal,

it is working fine from my end.....the problem when the users..once they logged in with their credentials..only some users are facing this problem.

for some users it is working fine.

Regards,

Rathnam.

[rathnam_qv]

Hi Ashfaq,

I am using same expression.i have implemented section access in this app.

once users logged in for some user it is coming properly for some user it's not.i am not able to find the issue.

Regards,

Rathnam.

[ashfaq_haseeb]

Do you have publisher?

how do you distribute?

Regards

ASHFAQ

[rathnam_qv]

No....i don't have Publisher

[ashfaq_haseeb]

Couple of things I can think of.

First take proper backup of QlikView Access point folder.

Then try by deleting server objects if any for that particular user.

Try by removing .shared and .meta file for that application.

Let me know if that worked.

Regards

ASHFAQ