topic Re: Multiple Guages, Different Where Clause in QlikView

Multiple Guages, Different Where Clause

Lisa2 — Sat, 16 Nov 2024 20:29:30 GMT

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 A	Colum B
Average	45
Average	25
Minimum	78
Minimum	65
Maximum	23
Maximum	89

Re: Multiple Guages, Different Where Clause

Lisa_P — Tue, 09 Jul 2019 22:59:46 GMT

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

Re: Multiple Guages, Different Where Clause

Lisa2 — Wed, 10 Jul 2019 13:16:26 GMT

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?

Re: Multiple Guages, Different Where Clause

Lisa2 — Wed, 10 Jul 2019 13:29:32 GMT

Never mind. Syntax error. Works great! Thanks!