topic Re: Summary Chart in QlikView

Summary Chart

Thu, 05 Mar 2015 13:50:30 GMT

Hey everyone,

I am working on this Action Items list where I want to kind of present a nice summary table. I have an idea of how I want it to look but not sure where to start. Any ideas.

Thanks

~Norman Rea

Re: Summary Chart

Gysbert_Wassenaar — Thu, 05 Mar 2015 13:56:17 GMT

Get the data first.

Next transform the data, if necessary.

Finally create the chart. It looks like a stacked bar chart will do the job.

Re: Summary Chart

giakoum — Thu, 05 Mar 2015 13:56:45 GMT

you could use a gauge chart for that

Re: Summary Chart

Thu, 05 Mar 2015 14:00:30 GMT

A gauge chart sounds like the right idea. So how can I get it to sum up the four areas based upon a due date?

Re: Summary Chart

giakoum — Thu, 05 Mar 2015 14:19:57 GMT

something like the attached?

Re: Summary Chart

Thu, 05 Mar 2015 14:23:43 GMT

I think that is going to work. Of course I need to put all the nice pretty stuff on it but I see how you did it.

Thanks!

Re: Summary Chart

giakoum — Thu, 05 Mar 2015 14:38:02 GMT

Welcome!

the nice pretty stuff usually takes 90% of the total time

Good luck!

Re: Summary Chart

Roop — Thu, 05 Mar 2015 14:43:57 GMT

Or a guage like this ....?

Re: Summary Chart

Thu, 05 Mar 2015 14:53:22 GMT

How do you recommend getting the labels on the bars and underneath?

Re: Summary Chart

Thu, 05 Mar 2015 15:03:21 GMT

Actually I can live without the labels on the chart itself I can do text boxes.

Re: Summary Chart

Thu, 05 Mar 2015 15:23:41 GMT

The one thing that would be nice though now that I am thinking of it is those values within the blocks.

That is becoming challenging.

Re: Summary Chart

Roop — Thu, 05 Mar 2015 15:48:42 GMT

Maybe we are looking in the wrong way .....

A chart may be better:

The advantage of such an approach is that it can be done by other dimensions and you could have relative values displayed so that it always showed the percentage of items that are past due.

I also attach the application.