topic PIVOT table: need to an expression is only function a part of dimension to my pivot table in QlikView

PIVOT table: need to an expression is only function a part of dimension to my pivot table

Fri, 08 Oct 2010 13:41:34 GMT

hi,

i make a QVW for explain my problem;

dimensions: TASK,PROJECT,TIME

expressions: SUM(ACTUAL), SUM(ETC)

Currently my 2 expressions are function of all dimensions in qvw and i would like SUM(ETC) expression is function of only the dimension TASK (not all dimension)

if someone can help me please

PIVOT table: need to an expression is only function a part of dimension to my pivot table

boorgura — Fri, 08 Oct 2010 13:59:20 GMT

Hi,

If you are looking for having TASK as the only dimension for ETC,

then you can use this logic:

sum(TOTAL <TASK> ETC)

Please let me know if it works. Also, feel free to ask if that is what you are not looking for.

PIVOT table: need to an expression is only function a part of dimension to my pivot table

Fri, 08 Oct 2010 14:46:03 GMT

thx rocky,

it is i would like in formula but don't in presentation,

currently l have

	TIME	2008	2008	2009	2009	2010	2010
PROJECT	TASK	SUM(ACTUAL)	SUM( TOTAL <TASK> ETC)	SUM(ACTUAL)	SUM( TOTAL <TASK> ETC)	SUM(ACTUAL)	SUM( TOTAL <TASK> ETC)
PROJECT1	TASK1	2	15	8	15	11	15
PROJECT2	TASK2	0	3	2	3	0	3
PROJECT2	TASK3	3	1	0	1	0	1
PROJECT2	TASK4	0	3	4	3	0	3
PROJECT2	TASK5	0	3	0	3	1	3

i would like (i dont want a duplication my expression for each YEAR (TIME)

	TIME		2008	2009	2010
PROJECT	TASK	SUM( TOTAL <TASK> ETC)	SUM(ACTUAL)	SUM(ACTUAL)	SUM(ACTUAL)
PROJECT1	TASK1	15	2	8	11
PROJECT2	TASK2	3	0	2	0
PROJECT2	TASK3	1	3	0	0
PROJECT2	TASK4	3	0	4	0
PROJECT2	TASK5	3	0	0	1

PIVOT table: need to an expression is only function a part of dimension to my pivot table

boorgura — Fri, 08 Oct 2010 17:08:28 GMT

In that case, you can have that a calculated dimension:

=aggr(sum(ETC), TASK)

And, of course, remove it from Expressions.

(For formatting purposes, please promote that above TIME)

Let me know if this works.

PIVOT table: need to an expression is only function a part of dimension to my pivot table

Mon, 11 Oct 2010 08:55:53 GMT

hi rocky,

it works very well and thx for your help and maybe this topic could be help someone else.

PROJECT	TASK	=aggr(SUM(ETC),TASK)	TIME	2008	2009	2010
PROJECT1	TASK1	0		-	-	11
PROJECT2	TASK2	3		-	2	-
PROJECT2	TASK3	1		3	-	-
PROJECT2	TASK4	3		-	4	-
PROJECT2	TASK5	3		-	-	1