topic Re: Set Analysis Expression in QlikView

Set Analysis Expression

sona_sa — Thu, 10 Jun 2021 05:22:27 GMT

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

sasikanth — Thu, 10 Jun 2021 05:56:19 GMT

Try Below Expression:

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

**please check date formats

sona_sa — Thu, 10 Jun 2021 06:19:33 GMT

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 — Fri, 11 Jun 2021 05:20:36 GMT

HI try below one

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