Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ev'ryone,
I'm trying to build a table in Qlik Sense that has 26 columns (each bound to an ID) plus two more column (Year + Measure) that shall have multiple rows (one for each year). So what I want is one row for the ID and the 25 following columns and then that row splitting into one row for each year and the value/measure for the respective year.
Somehow it seems that Qlik Sense won't let me create such a table.
In Qlikview this was no problem (see the screenshot to have an idea how it shall be)
Can anyone help, please?
Thank you in advance 🙂
Accepted Solutions
Hi,
Not sure I understood correctly your requirement, but let's try one answer.
Let me know if this solution gives you satisfaction.
What we can do with a pivot table (here with one ID and 2 columns + year and value, but you can add more columns) :
In the data section you select you ID + columns + years as dimensions, and value as measure :
In the configuration of the Pivot table you select these options to expend and do not indent the table :
Yes, sorry, depending of the Qlik version you are using you can do this (Cloud is ok, most recent On Prem version >= Feb 2024 I think) : you can do it by using the "Pivot table" you can find in "Custom objects / Qlik Visualization bundle" instead of the 'Pivot table" object you have in the standard charts.
You will get this... much better for you :
Regards,
Hi,
Not sure I understood correctly your requirement, but let's try one answer.
Let me know if this solution gives you satisfaction.
What we can do with a pivot table (here with one ID and 2 columns + year and value, but you can add more columns) :
In the data section you select you ID + columns + years as dimensions, and value as measure :
In the configuration of the Pivot table you select these options to expend and do not indent the table :
Hi SRA,
thanks a lot for the quick reply. Yes, good solution, seems I missed the presentation options.
The only thing which is really inconvenient is, that the dimension column labels are not placed well: not above each column, but in long row above the table.
Is there a way to place them where they belong, so one can immediately tell what each column displays without having to count columns? (see screenshot)
Greetz from the Buschdoktor
Yes, sorry, depending of the Qlik version you are using you can do this (Cloud is ok, most recent On Prem version >= Feb 2024 I think) : you can do it by using the "Pivot table" you can find in "Custom objects / Qlik Visualization bundle" instead of the 'Pivot table" object you have in the standard charts.
You will get this... much better for you :
Regards,
