Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
My be like:
Set vTable='Table1'; // Or, you can set the variable conditionally
$(vTable):
Load * Inline
[ A
1
]';
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.
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.