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: 
Not applicable

Gauge Chart

Hi all,

I am trying to create a gauge chart for one division. I want it to be locked so that when you select other divisions it doesn't change. If possible also locked on max year.

Expression:

  rangesum(above(total sum({1<DivisionName = 'XXX'>}RevenueAmount), 0, rowno(Total)))/rangesum(above(total sum({1<DivisionName = 'XXX'>}BudgetAmount), 0, rowno(Total)))

2 Replies
Not applicable
Author

you can use alternate states

Not applicable
Author

Yes I now got the gauge charts just the way i want them. Thanks!

Do you maybe got a clue how i can let them show the last week thats in the system.

Now i have to select the week from 2014 they'll show but is it possible they automatically select the last week?