topic Re: Simple (?) table calculation in QlikView

Simple (?) table calculation

Fri, 28 Feb 2014 09:33:48 GMT

A	B	C
		JAN
Machine	21	62,5
	26	4,4
	Cons.	4,1

I have a table as above and i would like to pick out the value from Cons. for JAN.

I have tried like this: sum(if(A='Machine' and B='Cons.',C)) but i only get 0 as result (should be 4,1).

What am i doing wrong?

Bets regards

/Mats

Re: Simple (?) table calculation

Fri, 28 Feb 2014 09:37:43 GMT

try this

sum(if(B='cons.',C))

Re: Simple (?) table calculation

kumarnatarajan — Fri, 28 Feb 2014 09:39:41 GMT

Hi,

Try below Syntex

Ex: Only({$<B={"Cons."},A={"Machine 2"}>}C)

Re: Simple (?) table calculation

MK_QSL — Fri, 28 Feb 2014 09:39:56 GMT

Can you provide more specific table data?

Re: Simple (?) table calculation

luis_pimentel — Fri, 28 Feb 2014 09:40:44 GMT

What values have the rows 2 and 3 for A? If they are blanck or null, try sum(if(B='cons.',C))

If their value is "Machine", your expression sum(if(A='Machine' and B='Cons.',C)) should work.

Regards.

Luis.

Re: Simple (?) table calculation

Fri, 28 Feb 2014 09:42:26 GMT

Ok, i did not tell all of it, sorry. In Column A i have several Machines, like this:

A	B	C
		JAN
Machine 1	21	62,5
	26	4,4
	Cons.	4,1
Machine 2	21	119,3
	26	6,3
	Cons.	6,3
Machine 3	21	45,5
	26	4
	Cons.	3,6

I want to for example pick out the value of Cons. for JAN only for machine 2

/Mats

Re: Simple (?) table calculation

Anonymous — Fri, 28 Feb 2014 09:48:39 GMT

First of all you have to create the data as shown below then you can use your expression

sum(if(A='Machine' and B='Cons.',C))

otherwise it would not give proper results .

You have merged cells in Field A,

Qlikview do not consider merged cells as one , it evaluates them as different cells so only first cell will have value and others So you have to populate them first.

A	B	C
		JAN
Machine 1	21	62,5
Machine 1	26	4,4
Machine 1	Cons.	4,1
Machine 2	21	119,3
Machine 3	26	6,3
Machine 4	Cons.	6,3
Machine 3	21	45,5
Machine 4	26	4
Machine 5	Cons.	3,6