Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
rmuhammad
Contributor

How to work effectively loading data from Crosstabs?

Hi All

I am new to QV and I am struggling with crosstabs when loading data into Qlikview. Experts please guide me on how to work effectively with these crosstabs.

For example this is how my data looks like

Oct-14Nov-14Dec-14Jan-15Feb-15Mar-15Apr-15
productsProduct DescSold to CustGross $QtyGross $QtyGross $QtyGross $QtyGross $QtyGross $QtyGross $Qty
gear1Jacket blueWalmart10215100866884144621472367229773102149885145168659710081726833
gear2Jacket RedTarget129419727133017155138871358962921407414025637610083774094669412
gear3Jacket BlackBay14229119199970601110060897912842141028814664014918844062417059

How do I script this, I tried Crosstab option but periods and 2 measures making it difficult.

Thanks

Rashid

Tags (4)
1 Reply
MVP & Luminary
MVP & Luminary

Re: How to work effectively loading data from Crosstabs?

Maybe you can use this: multi_header_pivot_import.qvw


talk is cheap, supply exceeds demand