Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
sudhakaran_abha
Creator
Creator

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
3 Replies
zebhashmi
Specialist
Specialist

Yes, can you search for the cross table?

may be this can help you

Creating a new column in the script

ahmar811
Creator III
Creator III

Hi abhay,

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

Capture.JPG

Regards

Ahmar

isingh30
Specialist
Specialist

Please check below link - You have to apply Generic Load

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

Thanks.