topic Re: Inverse function of Crosstable in App Development

Inverse function of Crosstable

isabelaadelina_ — Sat, 16 Nov 2024 02:01:38 GMT

Hi, a have a table like this one:

I want the highlighted field named "measure" to be split in different columns with them respective values( secondo field highlighted: so I will have the column named Units with the value 9, 25, 40, 22. Like an inverse function of Cross Table. Can I do it in Qlik Sense?

Thank You!

Re: Inverse function of Crosstable

Saravanan_Desingh — Tue, 30 Jun 2020 03:21:23 GMT

Are you looking something like this?

tab1: LOAD * INLINE [ ISO, Brand, measure, Date, Value 32, ABC, Units, 1/1/2018, 9 32, ABC, Units, 2/1/2018, 25 32, ABC, Units, 3/1/2018, 40 32, ABC, Units, 4/1/2018, 22 32, ABC, Units, 5/1/2018, 3 32, ABC, Units, 6/1/2018, 6 32, ABC, Units, 7/1/2018, 9 32, ABC, Units, 8/1/2018, 40 32, ABC, Units, 9/1/2018, 9 ]; Gen: Generic LOAD ISO, Brand, Date, measure&'_'&Value,'X' Resident tab1; Drop Table tab1;

Re: Inverse function of Crosstable

Vegar — Tue, 30 Jun 2020 05:32:49 GMT

@isabelaadelina_

Using generic load can solve your issue as @Saravanan_Desingh wrote in the previous answer. I recommend developers to read this post, The Generic Load by @hic , when introduced to the Generic function.

Re: Inverse function of Crosstable

Saravanan_Desingh — Thu, 02 Jul 2020 04:03:08 GMT

Did you look into the above solution provided?