topic Re: DISTINCT application_no in QlikView

DISTINCT application_no

Mon, 16 Mar 2015 09:16:56 GMT

can someone give me the correct code to run this, i cannot get it to work

I'm trying to count the amount of apps where the new date and the settlement date the same is

count(DISTINCT application_no, If(new_dates=settled_dates,'Y'))

simenkg — Mon, 16 Mar 2015 11:45:14 GMT

You create a flag in your script:

Load *,

if(new_dates = settled_date,1,0) as ValidFlag

from table...;

then your expression becomes:

count({<ValidFlag={1}>} application_no)

Anonymous — Mon, 16 Mar 2015 11:46:07 GMT

Hola,

Use this

count(distinct If(new_dates=settled_dates,application_no))

HTH

Mon, 16 Mar 2015 13:52:06 GMT

Hi @Francois

Try this Expression

=Count(DISTINCT If(new_dates = settled_dates, application_no))

Mon, 16 Mar 2015 13:54:43 GMT

I like this approch the best as well if its oemthign you going to use more then once. If not, a simple if works fine as well.