Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
swiftfahad
Contributor III
Contributor III

Problem in guage chart

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?

 

 

Labels (1)
2 Replies
swiftfahad
Contributor III
Contributor III
Author

16383419968506508856238867703027.jpg

 for reference and better understanding

jwaligora
Creator
Creator

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:

  1. 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!' 🙂
  2. 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))
  3. 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)