topic Re: How to Push the if statement to Script in QlikView

How to Push the if statement to Script

Mon, 30 Sep 2013 22:17:11 GMT

I have a expression like below:

COUNT

(DISTINCT(IF([Department Account Opened Date]>=$(vLastMonthstart)
AND [Department Account Opened Date]<=$(vLastMonthend) AND [Post Transaction Credit Amount]>=25,[Department Account Id])))

I would like to do this in script instead of Expression, Can you please point me in right direction

Thank you,

Re: How to Push the if statement to Script

manas_bn — Mon, 30 Sep 2013 22:38:48 GMT

Let vLastMonthstart = .... //Whatever you need.

Load *,

IF([Department Account Opened Date]>=$(vLastMonthstart)
AND [Department Account Opened Date]<=$(vLastMonthend) AND [Post Transaction Credit Amount]>=25, 1,0) as Dept_Acnt_Flag

Resident Your_Table;

In the front end, Count({$<Dept_Acnt_Flag={1}>} distinct [Department Account Id])

Re: How to Push the if statement to Script

Tue, 01 Oct 2013 05:30:04 GMT

HI,

Try this

Check:

LOAD Count(DISTINCT Department Account Id) AS Countval;

Load

IF([Department Account Opened Date]>=$(vLastMonthstart)
AND [Department Account Opened Date]<=$(vLastMonthend) AND [Post Transaction Credit Amount]>=25, Department Account Id) AS Department Account Id

Resident your label name;

Re: How to Push the if statement to Script

Tue, 01 Oct 2013 05:33:33 GMT

Hi,

You can also try like this

Check:

LOAD Count(DISTINCT Department Account Id) AS Countval;

Load

Department Account Id)

Resident your label name

Where

[Department Account Opened Date]>=$(vLastMonthstart)
AND [Department Account Opened Date]<=$(vLastMonthend) AND [Post Transaction Credit Amount]>=25

Re: How to Push the if statement to Script

rajeshvaswani77 — Tue, 01 Oct 2013 05:49:23 GMT

You have to load preceding load.

T1:

Load *, if statement;

Load

field1,

field2,

from tablename

Thanks,

Rajesh Vaswani

Re: How to Push the if statement to Script

Fri, 04 Oct 2013 02:02:59 GMT

Thanks everybody, It works