topic Guage settings in QlikView

Guage settings

Thu, 30 Apr 2015 14:35:50 GMT

Please could someone assist me with guage settings.

I have included an example.

I would like to see the full amount when I hover over the dial, not the rounded amount.

Also would it be possible to have a moving target for the budget

eg. Budget each month is £5833.

If my expression sums one month then let it be red after 5833

If my expression sums two months then let it be red after 11666 etc.

Very grateful for all assistance.

Re: Guage settings

Gysbert_Wassenaar — Fri, 01 May 2015 07:46:42 GMT

See attached qvw. I don't understand your second question. Your expression sums all months, which are all separate fields.

Re: Guage settings

Fri, 01 May 2015 07:54:49 GMT

Thank for your assistance with point one Gysbert. Please could you explain the expression to me. It is giving the answer I need.

With regards to the budget, I mean, if I were to select Jan and Feb and March, I would want the calculations to work for those month only for the sum and where the red starts.

Re: Guage settings

Gysbert_Wassenaar — Fri, 01 May 2015 08:08:13 GMT

About the dual function... see Dual & Exists – Useful Functions ‌and How to use- Dual().

You can't select Jan, Feb and March. They're field names, not field values. You can select 5833 and/or 0 in the field Jan. In the field Feb you can select 2010 and/or 5833. In the field March you select 3005 and/or 5833.