Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
mario-sarkis
Creator II
Creator II

set analysis

please how can i write this correctly in a set analysis

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

4 Replies
giakoum
Partner - Master II
Partner - Master II

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

you need a unique record identifier

prajapatiamar38
Creator II
Creator II

Hi....

Try like this:

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

antoniotiman
Master III
Master III

Hi Mario,

if Field1 <> all Field2 selected

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

If This is per row

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

Immagine.png

Regards,

Antonio

petter
Partner - Champion III
Partner - Champion III

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


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