Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

dynamic_girl
Contributor

set analsis expre

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?

16 Replies
prma7799
Honored Contributor III

Re: set analsis expre

MVP
MVP

Re: set analsis expre

May be this?


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

dynamic_girl
Contributor

Re: set analsis expre

what does * sign signifies over here

dynamic_girl
Contributor

Re: set analsis expre

its actually nt giving me desired output

Re: set analsis expre

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

Highlighted
dynamic_girl
Contributor

Re: set analsis expre

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

dynamic_girl
Contributor

Re: set analsis expre

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

dynamic_girl
Contributor

Re: set analsis expre

AVG (field)

where
field1= 'some value'

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

AND field <> 'NA'

Digvijay_Singh
Honored Contributor III

Re: set analsis expre

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