topic Re: Variable header in Qlikview in QlikView

Variable header in Qlikview

Sat, 17 May 2014 12:14:09 GMT

Hi,

I have a requirement where I need to add header labels in a different table and the data stored in a different table. I wanted to check if there was an option in Qlikview to handle this. Moreover the header is variable based on the type of record.

Thanks

Re: Variable header in Qlikview

tresB — Sat, 17 May 2014 12:26:54 GMT

My be like:

Set vTable='Table1'; // Or, you can set the variable conditionally

$(vTable):

Load * Inline
[ A
1
]';

Re: Variable header in Qlikview

Sat, 17 May 2014 18:20:20 GMT

I don't think I follow. I probably need to explain this better:

The headers are in table HEADER and the data is in table DATA. I now need to bring these together and use records in the HEADER table as column labels for the records in DATA table.

The HEADER records vary based on the type of record in DATA table.

Re: Variable header in Qlikview

Sat, 17 May 2014 20:11:59 GMT

I have now figured out a method which allows me to get Field names as header labels.

When using a table box this results in columns with null values in some cases. There is a way in the 'Presentation' tab to hide columns with null values using a condition like below:

If(IsNull(HDR17), 0, 1)

*** The columns with null values in Header table will always be null in Data table.