How can I write below sql statement in qlikview edit script and in set analysis

[#1]

  How can I write this sql statement in qlikview edit script and in set analysis.

if (MISC_FEE_RECURR_FLG='Y' ,

if ACTACC_RECURR_FLG ='Y',

then [Miscellenious Fee]+ [ActualAccount])) AS Reccuring

Thanks in advance.

[marcus_malinow · Accepted solution]

In your load script this would be

If(MISC_FEE_RECURR_FLG='Y' and ACTACC_RECURR_FLG='Y', [Miscellenious Fee] + [ActualAccount], Null()) as Reccuring

In set Analysis:

Sum({$<MISC_FEE_RECURR_FLG={'Y'},ACTACC_RECURR_FLG={'Y'}>}  [Miscellenious Fee] + [ActualAccount])

[#3]

Hey Aptha,

Please check out the attached file. Hope it helps you.

Thanks

AJ

[Anonymous]

Small note - set analysis is for the front end expressions.  Don't attempt it in script.

[#5]

Thank you all.

[#6]

Hi Aptha, we can't use the SET analysis type syntax in the Qlikview script.

Please use IF function to achieve the this type of requirements.