Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using data from DB to create a table.
Is it possible to reverse the display of rows and columns in the table? (without script)
as-is
to-be
date || 1/8/2023 | 1/7/2023 | ......
id || 3 | 1 | 1 | 2 |........
if its just for Display purpose, you can try using a pivot table
example below
Column dimension : Valueloop(1,FieldValueCount('DATE'))
AFAIK not without any scripting. The reverse way (crosstable-load) was included within the advanced section of the table-wizard in QlikView but not the generic-load - and I doubt that's different in Sense. But if you search for it you will various postings to this topic how to script it. Beside this you should have very good reasons to do such transformation because within the most scenarios it will have more disadvantages than benefits.
if its just for Display purpose, you can try using a pivot table
example below
Column dimension : Valueloop(1,FieldValueCount('DATE'))
Thank you!
Can I delete the "Values" and "=Valueloop(...)" above the pivot table?
you can hide the header row by injecting custom css using a MultiKPI object
div[tid="OBJECTID"] table tr:nth-child(1){
display:none!important;
}