Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everybody,
Need ur help....
In the bottom chart of the below attachment I want Quarter 2 i.e. Q2 to be the first bar followed by Q3 and Q4.
It should be in the following order Q2-Q3-Q4-Q1.
Could anyone help me how to achieve that?
Thanks in Advance.....
Hi,
Use the below in your script and when create List box or Chart , short it on the basis of Customshort
LOAD * INLINE [
Category, Customshort
Q2, 1
Q1, 4
Q3, 2
Q4, 3
];
Quite complex and unusable in the sort ....
I would compute the quarter as a new field in the script then, if the field name is eg. Quarter, then you can use my previous expression changing 'Q1' with 2014 Qty1 ... and so on
Anybody have idea how to use Match function for this?
thanks
Hi Sonali,
Try like this..
1) Take the Dimesion as 'Qrtr'
2) Enable the 'Expression' option in Sort tab and use the bellow expression.
Match(Qrtr,'Q2','Q3','Q4','Q1')
3) Write ur expression in Expression tab.
eg: Sum(Sales)
Reffer the atatched image for the same..
Regards,
Pradeep
while sorting write this expression .
it should work.
=wildmatch(Quarter,'Q2','Q3','Q4','Q1')
Thank you all for all your reply...
In sort tab I tried with:
=match(Quarter,'Q2','Q3','Q4','Q1')
And it worked
you marked your own answer correct while others are trying to help you and particularly mine was correct if u tried actually u would know that, first time i am seeing this kind of thing on community.
Hi Harshal,
Sorry for this..
Actually I am new to QlikView and new to QlikCommunity also. I thought there is some difference in wildmatch() and match().
So, I marked my answer as correct answer and your answer as helpful answer so that people will not confuse.
Thanks for helping me and making me correct.
Thanks & Regards,
Sonali Singh| Associate Software Engineer -Aon Project
Divyasree Technopolis, 124-125, Off Old Airport Road,
Bangalore 560 037 | India
Tel:91 9620195927 VoIP:+44 20718 25650
sonali.singh@cgi.com| cgi.com