topic Re: Data Representation in QlikView

Data Representation

Anonymous — Fri, 27 Feb 2015 07:16:44 GMT

d1	d2	e1	e2	e3	e4	e5	e6	e7	e8	e9	e10
a	x	34	34	88	78	77	99	21	77	44	33
a	x	45	43	98	44	44	33	22	33	49	23
a	v	33	44	44	77	66	55	55	83	10	44
a	x	12	11	77	32	77	66	49	66	22	55
b	y	21	10	44	1	56	99	67	45	21	44
b	y	33	23	99	33	66	23	44	22	19	89
b	y	67	89	22	77	44	33	45	21	9	99

I have two dimension d1 and d2 and rest e1 to e10 as expression.

I want representation like this in a table

d1 d2 e5 e6 e7 e8 e9 e10

x e2

v e2

b y e1

want to understand is that possible its a urgent requirement,

I have tried pivot table and upto third column that is e1,e2,e3,e4 but rest of e5 to e10 in normal format

i am not sure is that possible.

Anant

Re: Data Representation

MK_QSL — Fri, 27 Feb 2015 07:40:53 GMT

Humble Request : Always try to provide sample data in excel file which would be easier to reply..

Re: Data Representation

Anonymous — Fri, 27 Feb 2015 07:41:19 GMT

any help /suggestion guys?

Re: Data Representation

MK_QSL — Fri, 27 Feb 2015 07:42:41 GMT

Would like to try on this but need data in excel format.... if you can provide please...

Re: Data Representation

Anonymous — Fri, 27 Feb 2015 07:43:52 GMT

added excel.

Re: Data Representation

Anonymous — Fri, 27 Feb 2015 07:45:19 GMT

just added excel for ref inmy orignal post.

<<pfa>>

Re: Data Representation

MK_QSL — Fri, 27 Feb 2015 08:09:44 GMT

will try and come back to you on this..

Re: Data Representation

Fri, 27 Feb 2015 08:50:40 GMT

HI Anant Dubey,

This is not possible because. When you mean you want e1 to e4 horizontally and the rest vertically. You are trying to show e1 to e4 associated with e5 to e10 which seems to be not very logical to me.

This is only possible when e1 to e4 are some calculated dimensions. So i think you should specify exactly what these columns are to proceed.

Regards,

Shiva.

Re: Data Representation

kamalqlik — Fri, 27 Feb 2015 09:10:51 GMT

Hi Anant,

I don't think this will be possible.

Regards,

Kamal

d1	d2	e1	e2	e3	e4	e5	e6	e7	e8	e9	e10
a	x	34	34	88	78	77	99	21	77	44	33
a	x	45	43	98	44	44	33	22	33	49	23
a	v	33	44	44	77	66	55	55	83	10	44
a	x	12	11	77	32	77	66	49	66	22	55
b	y	21	10	44	1	56	99	67	45	21	44
b	y	33	23	99	33	66	23	44	22	19	89
b	y	67	89	22	77	44	33	45	21	9	99

d1	d2	e1	e2	e3	e4	e5	e6	e7	e8	e9	e10
a	x	34	34	88	78	77	99	21	77	44	33
a	x	45	43	98	44	44	33	22	33	49	23
a	v	33	44	44	77	66	55	55	83	10	44
a	x	12	11	77	32	77	66	49	66	22	55
b	y	21	10	44	1	56	99	67	45	21	44
b	y	33	23	99	33	66	23	44	22	19	89
b	y	67	89	22	77	44	33	45	21	9	99

d1	d2	e1	e2	e3	e4	e5	e6	e7	e8	e9	e10
a	x	34	34	88	78	77	99	21	77	44	33
a	x	45	43	98	44	44	33	22	33	49	23
a	v	33	44	44	77	66	55	55	83	10	44
a	x	12	11	77	32	77	66	49	66	22	55
b	y	21	10	44	1	56	99	67	45	21	44
b	y	33	23	99	33	66	23	44	22	19	89
b	y	67	89	22	77	44	33	45	21	9	99