Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

but we are required to do calculations at front end as creating a dynamic variable for dates as well.

Anonymous
Not applicable
Author

its a urgent requirement ,can you please help with the syntax for set analysis for the above ,

Anonymous
Not applicable
Author

hi sunny

set nalysis expert,kindly help.

field1='value' and (field2='NA' or isnull(field3)) and field4<>'NA' and (field5<>'null' or field6<>'null')

sunny_talwar

I suggest creating a flag in the script for doing this

If(field1='value' and (field2='NA' or isnull(field3)) and field4<>'NA' and (field5<>'null' or field6<>'null'), 1, 0) as Flag


and then just this

{<Flag = {1}>}

Anonymous
Not applicable
Author

thanks sunny ,will try that

Anonymous
Not applicable
Author

I tried with the above solution,

but its not giginvg me the correct result

why?

sunny_talwar

I have no idea what you have and what you tried.... so it will be difficult to say why... you will have to share more to get an answer to your why