Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
nakuldev
New Contributor II

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

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.

 

SalesGrowth
1020
3040
50

Thanks In Advance

Nakul