1 Reply Latest reply: Jan 23, 2015 9:54 AM by Gysbert Wassenaar RSS

    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