topic Re: Dinamic Table with 3 headers in App Development

Dinamic Table with 3 headers

Rodlibar — Fri, 15 Nov 2024 21:02:11 GMT

Hi, I need to convert the table 1 to table 2 example. Is it possible we make that?

Thanks in advance

Re: Dinamic Table with 3 headers

JonnyPoole — Fri, 08 Mar 2024 18:23:40 GMT

Its possible. Would take some time/iterations to do it. I would first restructure the 1st table into a table with only a single measure (IE: value) and more dimensions: Product, Num, Letters, OneSize, and a Classification field. Then you could create nested pivot table in the UI.

Most of the iterations, logic would be in the load script to convert the table into the single measured table.

Re: Dinamic Table with 3 headers

Rodlibar — Tue, 12 Mar 2024 12:09:39 GMT

Hi Jonny, thanks for reply.

Actually the first table is just the data visualization. We have here the data tables:

Re: Dinamic Table with 3 headers

JonnyPoole — Tue, 12 Mar 2024 12:58:27 GMT

I don't see 'cap', 'one', or 'onesize' in that data set... if possible supply the sample data in CSV, XLS, or TXT format including all values needed to replicate the pivot chart you shared above.

Also is this QlikView or Qlik Sense?

Re: Dinamic Table with 3 headers

Rodlibar — Wed, 13 Mar 2024 15:55:52 GMT

Hi Jonny, please, check below the qlik sense file.