topic Re: set analysis in QlikView

set analysis

mario-sarkis — Fri, 29 May 2015 11:38:10 GMT

please how can i write this correctly in a set analysis

sum({<Field1<>Field2>}amount)

giakoum — Fri, 29 May 2015 11:39:23 GMT

sum({<uniqueid={"Field1<>Field2"}>} amount)

you need a unique record identifier

prajapatiamar38 — Fri, 29 May 2015 11:43:21 GMT

Hi....

Try like this:

=Sum({<Field1={"<>Field2"}>}amount)

antoniotiman — Fri, 29 May 2015 12:18:13 GMT

Hi Mario,

if Field1 <> all Field2 selected

Sum({<Field1-=P(Field2)>} Amount)

If This is per row

Sum(If(Field1 <> Field2, Amount))

Regards,

Antonio

petter — Sat, 30 May 2015 01:04:04 GMT

giakoum‌is correct (almost) - you need to have an equal-sign after the first double quote " :

Sum( { < uniqueid = { "=Field1<>Field2" } > } amount )