Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Variable header in Qlikview

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Variable header in Qlikview

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.

View solution in original post

3 Replies
Highlighted
MVP
MVP

Re: Variable header in Qlikview

My be like:

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

$(vTable):


Load  * Inline
[ A
1
]';

Highlighted
Not applicable

Re: Variable header in Qlikview

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.

Highlighted
Not applicable

Re: Variable header in Qlikview

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.

View solution in original post