topic Re: Selecting a value based on different field in QlikView

Selecting a value based on different field

Tue, 02 Apr 2013 21:27:50 GMT

Hi Guys

My question is based on the sample table below. I would like to sum up the figures in column 'Value' (Blue) ONLY IF the text in column 'Name' reads 'Price' (Red). Please assist. I tried the following but i am not getting it right: "IF(Name like '%Price%', SUM({$} DISTINCT Value), value=0)"

TicketNumber	ParameterId	AccNumber	TicketCenter	TicketType	TicketGroup	Name	Value
T182268	3	A147	Installations	Instal	Installation	Price	499
T182268	4	A147	Installations	Instal	Installation	Engineer	Steve
T182268	5	A147	Installations	Instal	Installation	ProductId	501
T182268	6	A147	Installations	Instal	Installation	Username	adsl
T182268	7	A147	Installations	Instal	Installation	BillingPeriod	3
T182377	112	A368	Stock Allocation	Instal	Installation	Price	2356.38
T182377	113	A368	Stock Allocation	Instal	Installation	Engineer	Installer
T182377	114	A368	Stock Allocation	Instal	Installation	ProductId	268
T182377	115	A368	Stock Allocation	Instal	Installation	Username	adsl2
T182377	116	A368	Stock Allocation	Instal	Installation	BillingPeriod	1
T227681	221	A19	Customer Support	Customer Service	Support	Engineer	Andrew
T227681	223	A19	Customer Support	Customer Service	Support	Username	home

Kind Regards

Roots

Re: Selecting a value based on different field

Wed, 03 Apr 2013 02:01:36 GMT

Hi,

You can try this:

=if(Name = 'Price',sum(Value))

Regards,

Janzen

Re: Selecting a value based on different field

Wed, 03 Apr 2013 08:14:34 GMT

Thank you Janzen for the response, unfortunately its still not returning anything.

Strangely if i add another variable like: =if(Name = 'Price', Value, sum(Value)) it returns results but the problem is that it is picking the wrong values (looks like its picking the first figure it encounters even though it is not a Price.

Re: Selecting a value based on different field

Gysbert_Wassenaar — Wed, 03 Apr 2013 14:49:34 GMT

Try sum({<Name={'Price'}>} Value)

Re: Selecting a value based on different field

Mon, 08 Apr 2013 15:00:34 GMT

Thank you Gysbert, this solution worked perfectly.

Thank you Janzen for your assistance too.