topic Re: Problem in guage chart in QlikView

Problem in guage chart

swiftfahad — Wed, 01 Dec 2021 06:58:49 GMT

Hi!

I have to show bandwidth utilization on sheet for each transponder using chart. There are 57 transponder in data. With field allocated_capacity and utilized_capacity.

I m placing 57 guage chart with hardcoding transponder-id and readings for each transponder. But problem arrives when user narrow down selection and some chart shows bad min value in guage and looks of sheet went offward.

Is there any other way to represent it?

Re: Problem in guage chart

swiftfahad — Wed, 01 Dec 2021 07:01:11 GMT

for reference and better understanding

Re: Problem in guage chart

jwaligora — Sun, 05 Dec 2021 22:15:56 GMT

Not sure how many error conditions are possible, but for one, if the user selection is such that NO U_CAPACITY values corresponding to TRANS_ID=29 and PRODUCT_NAME=C-BAND exit (meaning sum({<TRANS_ID={29},PRODUCT_NAME={'C-BAND'}>}) = 0), you may get this error.

The issue is then likely related to the Max value in the Presentation tab. If so, there are several solutions, depending on your need/preference:

You can add a 'Calculation Condition' of sum({<TRANS_ID={29},PRODUCT_NAME={'C-BAND'}>}) U_CAPACITY) <> 0 , and edit the 'Error Message' to something sensible like 'Oops, you're not worthy!' 🙂
In the Presentation tab, in the Max field 'catch the exception' with an if statement and assign a fake, non-zero max value instead. if(sum({<TRANS_ID={29},PRODUCT_NAME={'C-BAND'}>}) U_CAPACITY) = 0, 1, sum({<TRANS_ID={29},PRODUCT_NAME={'C-BAND'}>}) U_CAPACITY))
Set the Max to the global max for the corresponding data subset by adding {1} into the set expression. sum({ 1 <TRANS_ID={29},PRODUCT_NAME={'C-BAND'}>}) U_CAPACITY)