Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-02-15 03:06 PM

Pivot Data in Qlik Load Script

Is there a way to pivot data in Qlik Load Script ?

Sample Data File:

NameSalaryMonthYear
John1000Jan 2018
Berry2000Feb 2018
Claire2500Mar 2018
John3000Feb 2018

Desired Output:

NameJan 2018Feb 2018Mar 2018
John10003000
Berry2000
Claire2500
5,559 Views
0 Likes
3 Replies
zebhashmi
Specialist
Specialist
‎2018-02-15 03:45 PM

Yes, can you search for the cross table?

may be this can help you

Creating a new column in the script

5,130 Views
0 Likes
ahmar811
Creator III
Creator III
‎2018-02-16 07:09 AM

Hi abhay,

Please find you desire output and also, find attached qvw file for more details.

Capture.JPG

Regards

Ahmar

Test.qvw
5,130 Views
0 Likes
isingh30
Specialist
Specialist
‎2018-02-16 08:26 AM

Please check below link - You have to apply Generic Load

https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic

Thanks.

5,130 Views
0 Likes