Hi All,

[#1]

Hi All,

How to write the below expression in set analysis:

=if((A - B)>=30 and (A - B) <=90 ,'border',if((A - B)>200 ,'crossed',if((A - B)< 0,'below',if((A - B)>=0 and (A - B)<30,'OK'))))@

[MayilVahanan]

Hi

You can't write this in Set Analysis.

You can use if condition in front end or

create a field in script and use that field in front end.

[vijetas42]

Hi,

You can not write such type of if expression in set analysis if possible try to use if condition or try to get calculated field for this expression from script.

[deepakqlikview_123]

Please make above calculation in the script

[avinashelite]

Hi Subharanjali,

we cannot achieve the comparison analysis using the set analysis, please you try with SQL and Qlikview script combination , that should solve the issue

[Anonymous]

you can use this expression in Script

load A,

B,

if((A - B)>=30 and (A - B) <=90 ,'border',if((A - B)>200 ,'crossed',if((A - B)< 0,'below',if((A - B)>=0 and (A - B)<30,'OK')))) as Diff_AB

from ...File

the simply use Diff_AB as dimension in your chart.

it will also increase your performance as well as simplicity in UI.

Thanks

BKC