topic Re: Need Help Urgent.... in QlikView

Need Help Urgent....

Fri, 09 May 2014 08:48:46 GMT

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.....

Re: Need Help Urgent....

alexandros17 — Fri, 09 May 2014 08:53:42 GMT

In the sort tab of your chart:

use sort by expression then write (using obviously your fields)

If(Quarter='Q2', 1, If(Quarter='Q3', 2, If(Quarter='Q4', 3, 4)) )

Let me know

Alexandros

Re: Need Help Urgent....

Fri, 09 May 2014 09:05:29 GMT

I Tried this..But it's not woking

Re: Need Help Urgent....

tresB — Fri, 09 May 2014 09:07:51 GMT

Fastest way of getting answered is to upload sample, see: Preparing examples for Upload - Reduction and D... | Qlik Community

Re: Need Help Urgent....

alexandros17 — Fri, 09 May 2014 09:08:45 GMT

Can you attach your document?

Re: Need Help Urgent....

SergeyMak — Fri, 09 May 2014 09:10:38 GMT

can you show the definition of Quaters from load script and Sort tab for your chart

Re: Need Help Urgent....

Fri, 09 May 2014 09:16:16 GMT

I Tried this..But it's not woking

Re: Need Help Urgent....

Fri, 09 May 2014 09:17:17 GMT

I have already attached the document

Re: Need Help Urgent....

SergeyMak — Fri, 09 May 2014 09:18:48 GMT

You attached an image, but not qlikview app

Re: Need Help Urgent....

Fri, 09 May 2014 09:24:03 GMT

In Dimention tab I have used this expression:

Replace( if(Souce.='Current Month' or
Souce. =Year(AddMonths(MonthEnd(Today()),-3)) & ' Qtr ' & Ceil(month(AddMonths(MonthEnd(Today()),-3))/3)
or
Souce. = Year(AddMonths(MonthEnd(Today()),-6)) & ' Qtr ' & Ceil(month(AddMonths(MonthEnd(Today()),-6))/3) ,
Souce.),'Current Month',Year((MonthEnd(Today()))) & ' Qtr ' & Ceil(month((MonthEnd(Today())))/3))

Re: Need Help Urgent....

ashwanin — Fri, 09 May 2014 09:30:15 GMT

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

];

Re: Need Help Urgent....

alexandros17 — Fri, 09 May 2014 09:33:44 GMT

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

Re: Need Help Urgent....

Fri, 09 May 2014 09:54:15 GMT

Anybody have idea how to use Match function for this?

thanks

Re: Need Help Urgent....

PradeepReddy — Fri, 09 May 2014 10:21:03 GMT

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

Re: Need Help Urgent....

Fri, 09 May 2014 10:23:26 GMT

while sorting write this expression .

it should work.

=wildmatch(Quarter,'Q2','Q3','Q4','Q1')

Re: Need Help Urgent....

Fri, 09 May 2014 11:21:39 GMT

Thank you all for all your reply...

In sort tab I tried with:

=match(Quarter,'Q2','Q3','Q4','Q1')

And it worked

Re: Need Help Urgent....

Thu, 15 May 2014 06:08:16 GMT

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.

Re: Need Help Urgent....

Thu, 15 May 2014 07:11:24 GMT

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