Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Multiple Guages, Different Where Clause

Hello,

I need to make three gauge charts. They will all use the max number of column B but where each gauge equals a different value from column A. I don't want a trellis chart. I don't know what should go in Dimensions (if anything) or what should go in Expressions or what settings should be set. If anyone could point me in the right direction. Thanks

Column AColum B
Average45
Average25
Minimum78
Minimum65
Maximum23
Maximum89
Labels (3)
1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Use the expression:
Gauge 1
max({<[Column A]={Average}>}[Colum B])
Gauge 2
max({<[Column A]={Minimum}>}[Colum B])
etc

View solution in original post

3 Replies
Highlighted
Employee
Employee

Use the expression:
Gauge 1
max({<[Column A]={Average}>}[Colum B])
Gauge 2
max({<[Column A]={Minimum}>}[Colum B])
etc

View solution in original post

Highlighted
Contributor
Contributor

That didn't work.  I got the error "No data to display."  Was there supposed to be something in the Used Dimensions box under the Dimensions tab?

Highlighted
Contributor
Contributor

Never mind.  Syntax error.  Works great!  Thanks!