topic Re: Help with gauge in table, please in QlikView

Help with gauge in table, please

Anonymous — Wed, 18 Mar 2015 11:43:18 GMT

Hi,

I want to make table of activities and show the progress of each group of activities.

Activities have unique ids (ActivityId) but are grouped by their name (ActivityName) and their status can be pending, started (ongoing) or completed. The status is stated by flags (flagIsStarted and flagIsCompleted), and each entry has its own line in the data, i.e. one line when it is started and one when it is completed.

I have calculated the number of total unique activities, the number of started and completed activities from the data and derived the number of activities in progress (started - completed), both in number and in percent.

My problem emerges as I try to add a gauge in the table showing the number of completed and ongoing in relation to the total number of activities in the group in different colours (green for completed, yellow for ongoing and red for not yet started). To me it seems like the numbers are added over the whole table in the graph, as I get the same values for gauges on all rows. The fact that if I select one group of activities it looks correct, but then I don't see the other ones.

I want the current progress status for each activity group.

For example, in the table below, Activity 1 should have been all yellow as both are started but none completed. Activity 3 should have been all red as none is started.

I have attached the example file.

Any ideas? 🙂

Re: Help with gauge in table, please

richard_pearce6 — Wed, 18 Mar 2015 11:58:06 GMT

Hi Erik,

I think I understand your problem.

You're trying to make the colours dynamic line by line and that's not how this chart works. These properties are set across the whole chart.

Richard

Re: Help with gauge in table, please

Anonymous — Wed, 18 Mar 2015 12:03:32 GMT

Hi Richard,

Yes, that is exactly what I want. If that is not a possible way forward, are there any other ways to achieve the same effect?

BR,

Erik

Re: Help with gauge in table, please

Roop — Wed, 18 Mar 2015 12:19:52 GMT

I think that this is what is required. You need to set the rule in the expression and then define the guage - See if you like it

Rupert

Re: Help with gauge in table, please

Anonymous — Wed, 18 Mar 2015 12:34:54 GMT

Thanks for your reply, Rupert, but that is not what I want to achieve.

Re: Help with gauge in table, please

Roop — Wed, 18 Mar 2015 12:42:53 GMT

How about this ....

You save a column of data by colouring the activities .....

Re: Help with gauge in table, please

Wed, 18 Mar 2015 13:05:54 GMT

Hi,

You can See attached QVW.

Re: Help with gauge in table, please

Roop — Wed, 18 Mar 2015 14:10:46 GMT

A better example:

Re: Help with gauge in table, please

Anonymous — Wed, 18 Mar 2015 21:32:07 GMT

Thank you, Krishnama, but I don't quite see what you mean.

Re: Help with gauge in table, please

Thu, 19 Mar 2015 05:52:30 GMT

Hi,

What you require from me. I also sent QVW . You do not keep expression in Gauge Properties. you can see attachment.

Re: Help with gauge in table, please

Anonymous — Thu, 19 Mar 2015 11:25:44 GMT

Ok, I see. The thing is that I, in that case, need meters for both Completed and OnGoing activities, and I don't think it is possible either. It looks like I have to solve/visualize it without using a table.

Too bad since it would have been the best.

Re: Help with gauge in table, please

Roop — Thu, 19 Mar 2015 11:38:42 GMT

You can have the bar doing 2 things at the same time. I have added a comment to ensure clarity to the user. This will allow a multi-faceted delivery:

I also attach the QVW file so that you can review - All the figures may be wrong but it gives an idea as to what is possible.

Hope it helps

Re: Help with gauge in table, please

Anonymous — Fri, 20 Mar 2015 08:56:05 GMT

The tricky part is that I need to show three variables.

I think that will be a bit confusing as the number of Completed activities rise, the number of OnGoing activities will diminish. Thus the the background will be red when when work is progressing well.

I have settled for another solution now. But if someone has a solution to my initial queation I'd be more than happy to know about it.

Thank you all for your time and interest.