Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello dears,
I have a list box including the Shamsi Months ( Months in Persian),
I tested all of the sort options (state,expressions,frequency...) but it does not get sorted as i wanted it to be.
I want to order them as it is in calender, apparently i have to sort them manually. but how?
thank you
Hi,
Go to chart properties, --> Sort --> use expression for sorting and use the below expression.
=Match([Shamsi Month,'فروردین','اردیبهشت','Mar in arabic','','')
make sure to use all Arabic month names.
by the way there was no data attached.
Regards
ASHFAQ
they are not Arabic Months, by the way, i tried that as the first effort. doesn't work
Hi,
sharing sample qvw file with data and expected output would be worth.
Regards
ASHFAQ
check again, the attached file is there!
thanks
Hi,
I have downloaded it. But its corrupted, I cannot open it.
Can you attached another version that i can open.
Regards
ASHFAQ
My expected output is instead of the picture shown in the first question, months should have this order: from right to left
فروردین--اردیبهشت--خرداد--تیر--مرداد--شهریور--مهر--آبان--آذر--دی--بهمن--اسفند
Hi,
Look at the attached image and QlikView file.
Hope it helped.
Regards
ASHFAQ
try this one :
that's all correct.. but i cannot open your qvd file, since i'm using the personal edition. if you tell me what you wrote in the expression part, i would be grateful
Hi,
Create a new qvw file and use the below script
load * Inline
[
Month,Year,Amount
فروردین,2013,500
اردیبهشت,2013,500
خرداد,2013,500
تیر,2013,500
مرداد,2013,500
شهریور,2013,500
مهر,2013,500
آبان,2013,500
آذر,2013,500
دی,2013,500
بهمن,2013,500
اسفند,2013,500
فروردین,2014,500
اردیبهشت,2014,600
خرداد,2014,600
تیر,2014,600
مرداد,2014,600
شهریور,2014,600
مهر,2014,600
آبان,2014,600
آذر,2014,600
دی,2014,600
بهمن,2014,600
اسفند,2014,600
]
Save and reload
Now drop your Month Field list box to your front end application.
Right click on month properties sort tab --> Select load order reversed.
Look at capture.jpg image attached.
Or
use the below expression to sort
=Match(Month,'اسفند','بهمن','دی','آذر','آبان','مهر','شهریور','مرداد','تیر','خرداد','اردیبهشت','فروردین')
Create bar chart with month as dimension and sum(Amount) as expression
Again go to chart properties --> sort tab of chat--> Select load order reversed.
Or
use the below expression to sort
=Match(Month,'اسفند','بهمن','دی','آذر','آبان','مهر','شهریور','مرداد','تیر','خرداد','اردیبهشت','فروردین')
Look at final output capture1.jpg
Regards
ASHFAQ