topic Re: Hi All, in QlikView

Hi All,

Mon, 01 Jun 2015 06:49:56 GMT

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'))))@

Re: Hi All,

MayilVahanan — Mon, 01 Jun 2015 06:54:15 GMT

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.

Re: Hi All,

vijetas42 — Mon, 01 Jun 2015 06:57:16 GMT

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.

Re: Hi All,

deepakqlikview_123 — Mon, 01 Jun 2015 07:05:07 GMT

Please make above calculation in the script

Re: Hi All,

avinashelite — Mon, 01 Jun 2015 07:13:02 GMT

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

Re: Hi All,

Anonymous — Mon, 01 Jun 2015 07:13:21 GMT

you can use this expression in Script

load A,

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