topic Re: How to get expressions? in QlikView

How to get expressions?

Wed, 19 Feb 2014 16:21:15 GMT

Hi,

I have to create straight and bar chart with below information. Can anyone help me with expression please as I tried but not able to make it exact data.

The requirement is

1) A summary of the successful Initials made.

Table

                  Week 1 Week 2 Week 3
No of Org
Initial made
% of Initial made

Bar chart showing week number on the horizontal axis and % of Initial made on the vertical axis.

2) A summary of the AD Order showing the number of appointments completed and the number of these that were proceeded.
Table
                                       Week 1 Week 2 Week 3
Appointments proceeded
WIP
Die
Appointments completed

Bar chart showing week number on the horizontal axis and % of appointments proceeded on the vertical axis.
Pie chart for the last week showing from the appointments completed, the % split between appointments proceeded, WIP and Die and any other.

Please find attached.

Thanks.

Re: How to get expressions?

Wed, 19 Feb 2014 16:54:45 GMT

Please can anyone help me as it is a bit urgent please

Re: How to get expressions?

Wed, 19 Feb 2014 17:02:44 GMT

Hi Amelia,

i am attaching QVW file worked on week numbers check it.

i hope it helps u.

Regards

Mahesh T

Re: How to get expressions?

Wed, 19 Feb 2014 17:06:06 GMT

Thanks,. I haven't found any attachment.

Re: How to get expressions?

Thu, 20 Feb 2014 10:08:15 GMT

Hi Mahesh,

I cannot able to open your document. Please can you attach the ones which I can able to open.

Thanks.

Re: How to get expressions?

Thu, 20 Feb 2014 11:01:39 GMT

Any Help please in file.

Re: How to get expressions?

Thu, 20 Feb 2014 11:33:29 GMT

Hi ,

i will attach check once and let me know.

regards

Mahesh

Re: How to get expressions?

Thu, 20 Feb 2014 11:38:39 GMT

Thanks and agian it is showing failed to open the document.

Re: How to get expressions?

Thu, 20 Feb 2014 11:43:20 GMT

Hi Amelia,

you do one thing.go to this link and in bottom side u have a link.

i hope it helps you.

http://ap.demo.qlik.com/detail.aspx?appName=Retailer%20EPOS%20Data%20Analytics.qvw

Re: How to get expressions?

Thu, 20 Feb 2014 11:44:25 GMT

Hi Amelia

i have sent you link to download the qvw is under moderating you will get it with in 15 minutes.

regards

Mahesh T

Re: How to get expressions?

Thu, 20 Feb 2014 11:45:14 GMT

Hi Mahesh,

Thanks for your help.

Re: How to get expressions?

Thu, 20 Feb 2014 12:16:59 GMT

Hi mahesh,

Is it still under moderating? because I can not able to see the download link.

Re: How to get expressions?

Thu, 20 Feb 2014 14:19:21 GMT

Any help please as this is very urgent for me now.

Re: How to get expressions?

Thu, 20 Feb 2014 14:28:10 GMT

Hi ,

find attachment notepad link is there.that one still moderating.

regards

Mahesh t

Re: How to get expressions?

Thu, 20 Feb 2014 14:41:49 GMT

Thanks for the URL. I will wait until the moderation is complete. I would like to see the expression holder.

Re: How to get expressions?

Thu, 20 Feb 2014 15:23:01 GMT

http://ap.demo.qlik.com/detail.aspx?appName=Retailer%20EPOS%20Data%20Analytics.qvw

Re: How to get expressions?

Thu, 20 Feb 2014 15:25:33 GMT

You can directly down load no needed for link.

check this attachment.@

regards

Mahesh T.

Re: How to get expressions?

Thu, 20 Feb 2014 16:34:23 GMT

Thanks. But I need the expressions behind the chart items, Is it possible to see the code?

Re: How to get expressions?

Thu, 20 Feb 2014 17:24:32 GMT

Yes you can download Qvw and can be able to open and see all the properties.

regards

Mahesh t

Re: How to get expressions?

Fri, 21 Feb 2014 08:56:08 GMT

I can able to open the file but I need the code behing this. so, actually in qvw if you go to ant chart item and if we right click we can able to see the properties. I need that properties. is it possible?