topic Re: Need Urgent help - creating weekly RAG dashboard in QlikView

Need Urgent help - creating weekly RAG dashboard

sayadutt — Wed, 27 Aug 2014 07:28:07 GMT

Hi Guys,

I have below data which I am loading from excel.

I am looking to create a qlikview report of the below format.

Can you please help here.

Thanks

Re: Need Urgent help - creating weekly RAG dashboard

maleksafa — Wed, 27 Aug 2014 07:34:09 GMT

if you attach a sample dashboard it would have been easier.

anyways, what you can do is first load the original data from excel and link the enddate to the master caledar table (which you need to populate) or simply add two dimension; the first one that will return the month name using the monthname function and the second one will return the week number using the week function, so now in your data model you have all the needed dimensions.

then start the design by creating a pivot table with application name, release no, month and week (add them by this order) as dimensions, and add an expression with is max(RYG status) (if there are more than one value) or only (RYG status) (if it is only one value), then you need to drag in the pivot table the month dimension above the expression tab in order to have the month and week dimension horizontally instead of vertically/

Re: Need Urgent help - creating weekly RAG dashboard

ecolomer — Wed, 27 Aug 2014 07:35:07 GMT

Use a dimension week(date) and expresion RYG Status

Re: Need Urgent help - creating weekly RAG dashboard

ashfaq_haseeb — Wed, 27 Aug 2014 07:45:36 GMT

Hi,

have a look at attached application.

Regards

ASHFAQ

Re: Need Urgent help - creating weekly RAG dashboard

sayadutt — Wed, 27 Aug 2014 07:50:11 GMT

Hi Ashfaq,

Could not relate this with my requirement. I guess you uploaded the wrong file.

Thanks

Re: Need Urgent help - creating weekly RAG dashboard

sayadutt — Wed, 27 Aug 2014 08:07:17 GMT

Hi Malek,

i am able to do it successfully.

1 enhancement:

can we replace the RYG texts with RYG Symbols? I mean if its Green, show a circle with Green color and like wise.

Thanks

Re: Need Urgent help - creating weekly RAG dashboard

MarcoWedel — Wed, 27 Aug 2014 09:42:39 GMT

Hi,

one possible solution:

hope this helps

regards

Marco

Re: Re: Need Urgent help - creating weekly RAG dashboard

MarcoWedel — Wed, 27 Aug 2014 10:28:23 GMT

maybe this helps also:

regards

Marco

Re: Need Urgent help - creating weekly RAG dashboard

sayadutt — Wed, 27 Aug 2014 15:31:30 GMT

Thanks Marco. This is what I am looking for.

Can I ask you for an enhancement for this request.

I have another field called as 'Comments'

I need to display the values of this field on the icons (Red, Amber, Green) when we move the mouse over it.

Can you guide me please.

Thanks

Re: Need Urgent help - creating weekly RAG dashboard

MarcoWedel — Wed, 27 Aug 2014 15:56:29 GMT

A mouse over pop up function does not seem to exist in this chart.

regards

Marco

Re: Need Urgent help - creating weekly RAG dashboard

MarcoWedel — Wed, 27 Aug 2014 16:06:06 GMT

as you have a seperate thread for the mouse over question here Displaying Field value on mouse hover (tooltip) in pivot chart, please close this thread if your initial question is answered.

thanks

regards

Marco