topic Re: Gauge Chart not showing up in QlikView

Gauge Chart not showing up

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the below data set. When I load it in my Qlikview script and create a gauge chart. It says bad min or max value.

I have given the Min Value = 0 and Max Value as "Fore casted Booking".

Please see the attachments.

Year	Actual Bookings	Forecasted Bookings
2014	2775	4500
2015	22243	10000
2016	6320	25000

Please suggest how to make it so it reflects the value in Gauge chart. Its happening because the value in second and third rows of Forecasted Bookings is high.

Please help

Re: Gauge Chart not showing up

Anil_Babu_Samineni — Thu, 08 Jun 2017 06:24:02 GMT

Try to give like below for your information [Fore casted Booking]

But, My suggestion is this for max? Max([Forecasted Bookings])

Re: Gauge Chart not showing up

Thu, 08 Jun 2017 06:39:58 GMT

Also I want to set a condition that the chart always show me the value for year 2016 and when selection is made in Year Field, it shows the data for that particular field. But if no selection, the data should be shown for 2016

Re: Gauge Chart not showing up

Anil_Babu_Samineni — Thu, 08 Jun 2017 06:42:27 GMT

Could be this?

If(GetFieldSelections(Year) = 1, Max([Forecasted Bookings]), Max({<Year = {'$(=Max(Year))'}>}[Forecasted Bookings]))

Re: Gauge Chart not showing up

Thu, 08 Jun 2017 06:44:53 GMT

No, its not working

Re: Gauge Chart not showing up

Anil_Babu_Samineni — Thu, 08 Jun 2017 07:54:05 GMT

Can you upload application and explain little more

Re: Gauge Chart not showing up

Thu, 08 Jun 2017 08:21:21 GMT

This is the gauge chart. Now it is showing me 63% as the value for the selected year i.e. 2014. This is changing with every selection made in year. My requirement is: When I open my application, it should show the value for 2016 (which is the max year) by default. It must change when a user selects other year.

Is this done by some condition? If yes also please tell where to put the condition.

Re: Gauge Chart not showing up

Anil_Babu_Samineni — Thu, 08 Jun 2017 09:59:27 GMT

Are you talking about Triggers, Would you able to share qvw, Please?

If it is related in triggers you may need to use Max(Year) as search string and Field as Year

Re: Gauge Chart not showing up

Thu, 08 Jun 2017 10:05:10 GMT

Thanks a lot. I did it with triggers. It worked