topic Re: sorting issue in QlikView

sorting issue

rathnam_qv — Wed, 01 Oct 2014 05:08:49 GMT

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.

Re: sorting issue

aveeeeeee7en — Wed, 01 Oct 2014 05:20:19 GMT

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

Re: sorting issue

perumal_41 — Wed, 01 Oct 2014 05:24:38 GMT

Hi,

is possible to upload sample app.

Re: sorting issue

amit_saini — Wed, 01 Oct 2014 05:27:04 GMT

Rathnam,

Like this???

Thanks,

Re: sorting issue

ashfaq_haseeb — Wed, 01 Oct 2014 05:37:07 GMT

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

Re: sorting issue

rathnam_qv — Wed, 01 Oct 2014 06:09:02 GMT

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.

Re: sorting issue

rathnam_qv — Tue, 07 Oct 2014 06:24:42 GMT

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.

Re: sorting issue

ashfaq_haseeb — Tue, 07 Oct 2014 06:50:26 GMT

Do you have publisher?

how do you distribute?

Regards

ASHFAQ

Re: sorting issue

rathnam_qv — Tue, 07 Oct 2014 06:55:45 GMT

No....i don't have Publisher

Re: sorting issue

ashfaq_haseeb — Tue, 07 Oct 2014 06:59:21 GMT

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