topic Re: Custom Total(Decision) in Pivot table based on the Cell value in QlikView

Custom Total(Decision) in Pivot table based on the Cell value

Wed, 26 Dec 2012 12:14:44 GMT

Hello i have a pivot table like this,

Dim1	Dim2	M	T	W
ASIA	source1	4	5	2
	source2	2	6	0
	source3	0	7	5
	Total(Decision)

So, Instead of taking total at the end i want to take some decion based on the values of souce1 source2 and source3 for every column.

for example, if in first row it should display Decision as EXE.

thanks

Lavi

Re: Custom Total(Decision) in Pivot table based on the Cell value

Thu, 27 Dec 2012 07:45:09 GMT

Any response for this question?

Re: Custom Total(Decision) in Pivot table based on the Cell value

neha_shirsath — Thu, 27 Dec 2012 09:13:50 GMT

Hello Harleen,

Can u pls tell me what exactly total u want to display.

Coz in chart property> In Presentation tab u can select Dimension & Expresion and check on Show partial sums.

Re: Custom Total(Decision) in Pivot table based on the Cell value

Thu, 27 Dec 2012 09:17:45 GMT

what you want exactly?

Re: Custom Total(Decision) in Pivot table based on the Cell value

Thu, 27 Dec 2012 09:28:35 GMT

@neha,

i don't want partial sums. if you look at above table,

for example for particular day values are

source 1 4

source 2 2

Source 3 0

Result EXE

So because Source3 has value Zero so i want to show Result is EXE. So, instead of showing sum at the End i want to show some Characters based on the above 3 values.

In the same way for second column values 5 ,6 7. I will say Result is OK.

So , some kind of Custom Total.

thanks

Harleen

Re: Custom Total(Decision) in Pivot table based on the Cell value

Thu, 27 Dec 2012 09:32:56 GMT

right clik on pivote-- > presentation---> select dimension ---> check on show partial sum

add expression and write ( Column(1) + Column(2) + Column(3) )

hope it helps you

Re: Custom Total(Decision) in Pivot table based on the Cell value

Thu, 27 Dec 2012 09:55:27 GMT

Vishwaranjan,

There is only one expression in the above pivot table.

so Column1 + Column2 + Column3 doesn't exisit.

Dim1 and Dim2 are Dimensions

and Monday(M), (Tuesday)(T) is also a dimension.

thanks

Harleen

Re: Custom Total(Decision) in Pivot table based on the Cell value

Thu, 27 Dec 2012 10:00:20 GMT

what you exactly want the total?

i think if you take all field as dimension then write sum(M+T+W).

Re: Custom Total(Decision) in Pivot table based on the Cell value

er_mohit — Thu, 27 Dec 2012 11:29:13 GMT

hiii

use name and id in dimension and through inline function in script add total field value in same field of source

then use expression for M,T and W

alt(if(name='total' and tue=0,'ok',

if(name='total' and tue<>0,'exe',tue)))

hope it helps you