topic Re: How can I write below sql statement in qlikview edit script and in set analysis in QlikView

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

Tue, 21 Jan 2014 17:50:24 GMT

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 — Tue, 21 Jan 2014 17:54:26 GMT

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])

Tue, 21 Jan 2014 18:01:29 GMT

Hey Aptha,

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

Thanks

Anonymous — Tue, 21 Jan 2014 18:20:35 GMT

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

Tue, 21 Jan 2014 21:31:20 GMT

Thank you all.

Tue, 21 Jan 2014 22:08:02 GMT

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.