I need to split data onto different sheets

[rittermd]

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.

Thanks

[karthikoffi27se]

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.

Thanks

Karthik