Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
isabelaadelina_
Partner - Contributor
Partner - Contributor

Inverse function of Crosstable

Hi, a have a table like this one: 

isabelaadelina__1-1593486067907.png

 

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!

 

Labels (1)
3 Replies
Saravanan_Desingh

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;

commQV04.PNG

Vegar
MVP
MVP

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

Saravanan_Desingh

Did you look into the above solution provided?