Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Set Analysis Expression

Hi,

Can anyone convert this expression in Set Analysis - 

Count(DISTINCT If((DOL1='01/01/1900' or DOJ >= Date(Today(),'DD/MM/YYYY')),Code))

Thanks

Labels (1)
3 Replies
sasikanth
Master
Master

 

Try Below Expression:

Count( distinct { <DOL1={'01/01/1900'}>+<DOJ = { '>=$(=Date(Today(),'DD/MM/YYYY'))'} >} Code)

**please check date formats

sona_sa
Creator II
Creator II
Author

Hi Sasi,

By using this expression, one part is working that is {'01/01/1900'} but after OR part is not working. Data is missing.

DOJ = { '>=$(=Date(Today(),'DD/MM/YYYY'))' 

is not working.

You can check with attached xls.

Thanks.

sasikanth
Master
Master

HI try below one

Count( distinct { <DOL1={'01/01/1900'}>+<DOJ = { ">=$(=Date(Today(),'DD/MM/YYYY'))"} >} Code)