Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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 (2)
3 Replies
Highlighted
Specialist III
Specialist III

Re: Inverse function of Crosstable

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

Highlighted
Partner
Partner

Re: Inverse function of Crosstable

@isabelaadelina_ 

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Specialist III
Specialist III

Re: Inverse function of Crosstable

Did you look into the above solution provided?