topic Re: set analsis expre in QlikView

set analsis expre

Anonymous — Fri, 09 Feb 2018 06:19:00 GMT

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?

Re: set analsis expre

prma7799 — Fri, 09 Feb 2018 06:38:07 GMT

Look here

AND OR combination condition in set analysis | Qlik Community

Re: set analsis expre

tresB — Fri, 09 Feb 2018 06:42:06 GMT

May be this?

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

Re: set analsis expre

Anonymous — Mon, 12 Feb 2018 08:25:10 GMT

what does * sign signifies over here

Re: set analsis expre

Anonymous — Mon, 12 Feb 2018 08:25:27 GMT

its actually nt giving me desired output

Re: set analsis expre

sunny_talwar — Mon, 12 Feb 2018 13:26:40 GMT

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

Re: set analsis expre

Anonymous — Mon, 12 Feb 2018 16:35:52 GMT

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

Re: set analsis expre

Anonymous — Mon, 12 Feb 2018 16:37:35 GMT

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

Re: set analsis expre

Anonymous — Mon, 12 Feb 2018 16:39:06 GMT

AVG (field)

where
field1= 'some value'

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

AND field <> 'NA'

Re: set analsis expre

Digvijay_Singh — Tue, 13 Feb 2018 00:50:29 GMT

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

Re: set analsis expre

Anonymous — Tue, 13 Feb 2018 05:22:31 GMT

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

Re: set analsis expre

Anonymous — Tue, 13 Feb 2018 05:27:34 GMT

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

Re: set analsis expre

Anonymous — Tue, 13 Feb 2018 06:07:40 GMT

hi sunny

set nalysis expert,kindly help.

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

Re: set analsis expre

sunny_talwar — Tue, 13 Feb 2018 10:05:13 GMT

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}>}

Re: set analsis expre

Anonymous — Thu, 15 Feb 2018 06:25:11 GMT

thanks sunny ,will try that

Re: set analsis expre

Anonymous — Tue, 20 Feb 2018 07:04:57 GMT

I tried with the above solution,

but its not giginvg me the correct result

why?

Re: set analsis expre

sunny_talwar — Tue, 20 Feb 2018 10:00:39 GMT

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