topic Put a field name in Column Heading in QlikView

Put a field name in Column Heading

Mon, 11 Jun 2012 20:17:39 GMT

I need to get a field value to show in the column heading in a straight table. The column heading (AuxReasonDescription) is in the following table:

The following script works to get the "y" in the label but I can't get it to show the AuxReasonDescription instead of "y":

=if(count({$<AuxReasonCode={'1'}>}AuxReasonDescription)>0,'y','n').

Any help would be appreciated.

swuehl — Mon, 11 Jun 2012 20:23:58 GMT

Try

=only({<AuxReasonCode={1}>} AuxReasonDescription)

Mon, 11 Jun 2012 20:26:22 GMT

That worked!! Thanks so much.