Hiding lines with zero value from pivot table

[#1]

Hello All,

I am having a table where I want to exclude lines with zero value.

Is there a have only those dimension where value exist?

Thanks in advance.

Regards,

IK

[#2]

Hi,

You can use if(len(dimension)>0,dimension)

Also this can be handled from scipt side.

Please be more descriptive or please share a sample qvw as your question is not clear.

Regards

[qlikview2015]

Hi !

You can use this in the Chart Properties:

Best Regards

Mike Preuss