Table rows and columns

[louise119]

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 |........

[marcus_sommer]

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.

[vinieme12 · Accepted solution]

if its just for Display purpose, you can try using a pivot table

example below

Column dimension :   Valueloop(1,FieldValueCount('DATE'))

[louise119]

Thank you!

Can I delete the "Values" and "=Valueloop(...)" above the pivot table?

[vinieme12]

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;
}