Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

DISTINCT application_no

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

4 Replies
Highlighted
Partner
Partner

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)

Highlighted
Creator III
Creator III

Hola,

Use this

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


HTH

Highlighted
Not applicable

Hi @Francois


Try this Expression


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

Highlighted
Not applicable

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.