If condition in edit script

deepakkrish — Sat, 16 Nov 2024 00:11:56 GMT

Hi All,

How to write this IF condition in edit script .

=Alt(num(1.25*(count({<Status={'Good'},Activestatus={'Active'},Renewalstatus={'Yes'},
Type={'Renewal'},Stage={'Propose'},[EOD Quarter]=>}ID)

count({<Renewals=,Activestatus={'Active'},Renewalstatus={'Yes'},Type={'Renewal'},Stage={'Propose'},[EOD Quarter]=>}[ID])),'#.##'),0)

Thanks,

Deep.

Re: If condition in edit script

Kushal_Chawda — Tue, 04 Aug 2020 11:29:00 GMT

You won't be able to write entire condition in script as it involves exclusion of some filter which is only front end feature. But you can create the Flags in script and use it to simplify the expression.

load *,

if( Status='Good' and Activestatus='Active' and Renewalstatus='Yes' and
Type='Renewal' and Stage='Propose', 1,0) as Numerator,

if(Activestatus='Active' and Renewalstatus='Yes' and
Type='Renewal' and Stage='Propose',1,0) as Denominator

FROM Source

Now you can use below formula on front end

=num(1.25*(Sum({<[EOD Quarter]>}Numerator)) / sum({<Renewals,[EOD Quarter]>}Denominator) ,'#.##')

topic If condition in edit script in QlikView

If condition in edit script

Re: If condition in edit script