set analsis expre

[Anonymous]

AVG (field)

where
field1= 'some value'

AND (field2 = 'some value'OR field IS NULL)

AND field <> 'NA'

this needs to be done on set analysis

how?

[prma7799]

Look here

AND OR combination condition in set analysis | Qlik Community

[tresesco]

May be this?

AVG ({<field-={'NA'}, field1={'some value'}>*(<field2={'some value'}>+<field2={"=Isnull()"}>)}field)

[Anonymous]

what does * sign signifies over here

[Anonymous]

its actually nt giving me desired output

[sunny_talwar]

Would you be able to share a few rows of data and explain what you need to get as your expected output from it?

[Anonymous]

So this is the code in sql, am cnvertng this to set analysis expresion

[Anonymous]

So the output is nt matchng with the sql code  is the syntax fine?

[Anonymous]

AVG (field)

where
field1= 'some value'

AND (field2 = 'some value'OR field IS NULL)

AND field <> 'NA'

[Digvijay_Singh]

Any reason for not filtering it while loading from SQL. Most of the time same SQL statement exactly works in load script.