Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
LP27
Creator II
Creator II

CrossTable in Qlik sense

Hi Everyone,

I need to achieve this in load script using CrossTable function. Not sure if this can be done for the below scenario

my  sample dataset looks like this - 

IdNameTitle Value
1TMOSentYes
1TMOStatusTransit
1TMODays Taken3
2PROSent No
2PROStatusDispatched
2PRODays Taken5

 

Now I need to achieve into this

IDNameSentStatusDays Taken
1TMOYesTransit3
2PRONo Dispatched5

 

How do i get this with Cross Table or is there any other way to get the above output.

Kindly assist me here!

 

Thanks in advance!!!!

1 Reply
MayilVahanan

HI @LP27 

Actually, you need to use Generic load. Please refer the doc for it.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470

 

Thanks & Regards,
Mayil Vahanan R