Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
is possible to upload sample app.
Rathnam,
Like this???
Thanks,
AS
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
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.
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.
Do you have publisher?
how do you distribute?
Regards
ASHFAQ
No....i don't have Publisher
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