Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Column wise data use in row wise..

How to i am use my excel sheet column data in row wise because qlikview are only read data row wise...

4 Replies
MVP
MVP

Re: Column wise data use in row wise..

You can transform the data using qv wizard. Learn about crosstable() as well.

jyothish8807
Honored Contributor II

Re: Column wise data use in row wise..

You can use the concept of cross table. Can you share your workbook so that we can take a look into it?

Regards

KC

Best Regards,
KC
kushalthakral
Contributor II

Re: Column wise data use in row wise..

Dear Priyatam

Please share your excel file for better understanding.

Regards

Kushal T

Re: Column wise data use in row wise..

Crosstable prefix to a LOAD statement generates new rows per column with at least one common column as first columns.

hope this helps

regards

Marco

Community Browser