Discussion board where members can get started with QlikView.
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'))
You create a flag in your script:
if(new_dates = settled_date,1,0) as ValidFlag
then your expression becomes:
Try this Expression
=Count(DISTINCT If(new_dates = settled_dates, application_no))
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.