topic Re: Transpose/ Cross Table in Excel Binary WorkBook Format to EXCEL - Scripting Issue in QlikView

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

lakshmanvepuri — Sat, 16 Nov 2024 01:02:23 GMT

HI All,

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 )

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

2. Transpose as given below with splitting as below.

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

lakshmanvepuri — Tue, 17 Mar 2020 16:13:48 GMT

Hi all,

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

Thanks a lot

LK vepuri

Saravanan_Desingh — Mon, 27 Apr 2020 03:33:20 GMT

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