In Bar chart where ever the value is zero or Null it should neglect the entire line item

nakuldev — Sun, 03 Jun 2018 12:21:24 GMT

Hi All,

In the attached qvw the bar chart consists of few single line item values and average is showing up correct but Bar offset is going wrong for few Labor type(Application Engineer/ Application technician).

In "Labor Rates Graph" tab, if count of standard rate(expression) is <=1,avg(expression),min(expression)........but the expression which I wrote is not working .

In "Full cost Build up" tab, we have button to switch b/w Value and %. Switch to value is showing the exact data but switch to % is not working. The requirement is wherever a value in the column is 0 or null it should not consider the entire row.

For example: If we have Sales and growth columns where sales/growth should be 40/60 instead of 40/110 as per the below table.

Sales	Growth
10	20
30	40
	50

Thanks In Advance

Nakul

topic In Bar chart where ever the value is zero or Null it should neglect the entire line item in QlikView

In Bar chart where ever the value is zero or Null it should neglect the entire line item