topic Re: How to deconstruct a crosstable - do I have to? in QlikView

How to deconstruct a crosstable - do I have to?

josephinetedesc — Tue, 29 Sep 2015 04:37:07 GMT

Hi I have a problem with a crosstable -

It makes sense to have it as a crosstable when people are viewing it to get information as it is clearer and cleaner.

However when I then want to use it in QlikView, it seems to work only when I have deconstructed it and saved it as a table with 2 dimensions as shown below. Is there an easy way to construct the crosstable to work as shown below? Even if I could do it in Excel it would be terrific.

I have loaded it as a crosstable but I needed to change it to get to work when I wanted to re-use it. I am going to try again though!

date	M1	M2
1/01/2015	10	20
2/01/2015	12	15
3/01/2015	14	16
4/01/2015	10	20
5/01/2015	12	15
6/01/2015	14	16
date	mins	machine
1/01/2015	10	M1
2/01/2015	12	M1
3/01/2015	14	M1
4/01/2015	10	M1
5/01/2015	12	M1
6/01/2015	14	M1
1/01/2015	20	M2
2/01/2015	15	M2
3/01/2015	16	M2
4/01/2015	20	M2
5/01/2015	15	M2
6/01/2015	16	M2

Re: How to deconstruct a crosstable - do I have to?

Anonymous — Tue, 29 Sep 2015 04:44:02 GMT

Hi,

Have a look:

Cross Table

Hope it helps!!

Re: How to deconstruct a crosstable - do I have to?

tresB — Tue, 29 Sep 2015 04:47:06 GMT

Not sure if I understood right. Assuming you got the second table from the first one using crosstable and not want to go back to the table1 structure. If that is the case, try with pivot table.

Dim1:Date

Dim2: machine

Exp: Sum(mins)

Now drag the second dimension up to the right corner. Is it what you are looking for?

Re: How to deconstruct a crosstable - do I have to?

josephinetedesc — Tue, 29 Sep 2015 04:51:39 GMT

I had the first table - had to deconstruct to get the second table. But it was hard work to get to the second table. I am wondering if there is an easier way that manual copy/paste in Excel or if QlikView could do it? (But I think it does do it behind the scenes ...) I think I must have done something else "wrong"