Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful