Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table I am trying to format so that the comments column is presented below the other columns of data.
In Access, I am able to create a "Detail Header" with all the columns of data except for comments showing in each "Detail Header" with the comments columns displaying in the "Detail". All the needed data currently resides in the same table.
I am trying to get the same type of format in Qlik.
Any thoughts or direction is greatly appreciated.
Attached is a screenshot.
Hi
Just give a try
Add your main fields as dimensions
Add Comments as last dimension
Turn on “Always fully expanded”
Thank you but that did not work.
I need to last column to display as a separate line below all the other columns. In other words, multiple columns of data in Line A and the related comment in Line B all the way down the page.
Try Dimensionality() function,this is used to achieve these kind of goals. if you arent able to achive, attach some sample data and the output.
Thanks