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: 
ashis
Creator III
Creator III

Linear Gauge chart value

Hi ,

I am trying to plot a linear gauge chart in a straight table . Following is the expression for the chart

=sum(DependOnDiff)/aggr(sum(TOTAL DependOnDiff),DependsON)

In Gauge setting Min is 0 and Max is 1. and only one segment is selected.

The problem is not all the bar are shown , there are few that has value however it is not displayed in the gauge chart. I am wondering why .

Any idea.

Kind regards,

Ashis

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

try this

=sum(DependOnDiff)/aggr(noditstinct  sum(TOTAL DependOnDiff),DependsON)

View solution in original post

6 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

try this

=sum(DependOnDiff)/aggr(noditstinct  sum(TOTAL DependOnDiff),DependsON)

ashis
Creator III
Creator III
Author

Thank you Liron, it works. Thank you for your help.

what is the difference from the previous expression where I did not use nodistinct .

Anil_Babu_Samineni

Please close this thread by flag correct answer as you already got the answer.

And, FYQ - NoDistinct helps to sum for all values (i.e. not only unique numbers)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ashis
Creator III
Creator III
Author

Hi Anil,

Thank you for your answer.

I would close this tread as correct answer , however I do not see this option .

ashis
Creator III
Creator III
Author

Hi Jens,

Thank you for quick reply. Even if I use only one dimension as jobname , I get only one bar instead of two bars.

since the job has started twice I need to plot two bars instead of one.

Anil_Babu_Samineni

Have a look Qlik Community Tip: Marking Replies as Correct or Helpful

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)