Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshmanvepuri
Creator
Creator

Transpose/ Cross Table in Excel Binary WorkBook Format to EXCEL - Scripting Issue

HI All,

@sunny_talwar 

Need Help in LOAD Issue Issue, I have update the requirement in the excel binary workbook.

1 . Need to load data from ROW 7 on wards. ( Delete the Previous Rows )

 Additional_Req.png

1Q19 BASE Qty should be taken 1Q19  -- BASE QTY --- Value

2. Transpose as given below with splitting as below.

Result.png

3. Data is volume is high and is not limited...( Columns and ROWS are More)

4. Enclosing the Requirement Excel Binary WorkSheet. Please help on the scenario ( Enclosed in ZIP Format )

 

Thanks in Advance,

LK Vepuri

 

1 Solution

Accepted Solutions
saran7de
Master
Master

Hi, Please see my solution which is similar to your requirement. Try this out. Otherwise let me know.

https://community.qlik.com/t5/QlikView-Scripting/CrossTable-Transpose-Rotate/td-p/1555627

View solution in original post

2 Replies
lakshmanvepuri
Creator
Creator

Hi all,

 

please help me on this.. I am struck up here .. 

 

Thanks a lot

LK vepuri

saran7de
Master
Master

Hi, Please see my solution which is similar to your requirement. Try this out. Otherwise let me know.

https://community.qlik.com/t5/QlikView-Scripting/CrossTable-Transpose-Rotate/td-p/1555627

View solution in original post