Column in chart that reflects names of other columns in chart

[hjm35055]

Hi,

I have a chart in QlikView that is similar to the chart below but with more columns.  What I am trying to do is create the column highlighted in yellow. I want to list the column headers where the value is greater than 0.  The expressions for the columns are below.

Blank Entity ID:  sum([_Null Entity ID]

Blank Year:  sum([_Null Year]

Blank Period:  sum([_Null Period]

Blank Product ID:  sum([_Null Product ID]

Thank you!

[Anil_Babu_Samineni]

You mean to say you need to fetch the label names of expression when >0 of your metric. Isn't it ??

[arvind_patil]

HI Hannah,

May be below expression help you.

if(is null(Column(2),[Data Issues],'Value')

Thanks,

Arvind Patil

[hjm35055]

yes