Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

dynamic_girl
Contributor

Re: set analsis expre

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

dynamic_girl
Contributor

Re: set analsis expre

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

dynamic_girl
Contributor

Re: set analsis expre

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

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

dynamic_girl
Contributor

Re: set analsis expre

thanks sunny ,will try that

dynamic_girl
Contributor

Re: set analsis expre

I tried with the above solution,

but its not giginvg me the correct result

why?

Re: set analsis expre

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