1 Reply Latest reply: Jun 23, 2016 4:31 PM by Karthik S RSS

    I need to split data onto different sheets

    Mark Ritter

      I am replicating an excel spreadsheet that has multiple tabs.


      I have a dimension with 3 values.  Let's just say A,B,& C.


      I want A data to be on Sheet1.  B data to be on Sheet2.  and C data to be on Sheet3.


      The metrics and layouts on each sheet are the same.  Just want different data on each.


      I hope this explanation makes sense.



        • Re: I need to split data onto different sheets
          Karthik S

          Hi Mark,

          Can you share bit more details please.

          When you say you want to replicate A Dimension in Sheet 1, Do you mean in QlikView?

If you want A Dimension alone in QlikView - Sheet 1 just add the dimensions on the object you are using ignoring B and C, same applies for Sheet 2 & 3.

          Please advise if I am wrong.