Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with gauge in table, please

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? 🙂

12 Replies
richard_pearce6
Luminary Alumni
Luminary Alumni

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

Anonymous
Not applicable
Author

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

Roop
Specialist
Specialist

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

Anonymous
Not applicable
Author

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

Roop
Specialist
Specialist

How about this ....

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

Not applicable
Author

Hi,

You can See attached QVW.

Roop
Specialist
Specialist

A better example:

example.png

Anonymous
Not applicable
Author

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

Not applicable
Author

Hi,

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