topic Re: The date varible in set analysis not working. in QlikView

The date varible in set analysis not working.

baylor2016 — Thu, 05 Jan 2017 03:34:48 GMT

Hi,

I have tried to find many different ways to make the date variable work in my set analysis - to limit the people's age (18-75) based upon the date selected, but not success. Here are what I have tried:

=count(

FLAG_DM={1}

,YEARSSINCELASTVISIT={"<4"}

,BIRTH_DATE = {"<=$(=$(timestamp(DOB18)))>=$(=$(timestamp(TESTDATE)))"}

DISTINCT PAT_ID

)

=count(

PAT_ID=

{'=FLAG_DM=1'}

*{'=YEARSSINCELASTVISIT < 4'}

*{'=Date(BIRTH_DATE)+6775>today()'}

*{'=date(BIRTH_DATE)+27394<today()'}

DISTINCT PAT_ID

My sample project is attached.

Please help. Thanks

Longmatch

Re: The date varible in set analysis not working.

parimikittu — Thu, 05 Jan 2017 05:47:38 GMT

BIRTH_DATE = {"=$(=timestamp(TESTDATE))"}. This is the correct syntax.

Re: The date varible in set analysis not working.

baylor2016 — Thu, 05 Jan 2017 13:37:38 GMT

This is my question- the correct syntax does not work in my project. Please look at my attached sample. Thanks

Re: The date varible in set analysis not working.

parimikittu — Fri, 06 Jan 2017 11:10:05 GMT

Re: The date varible in set analysis not working.

parimikittu — Fri, 06 Jan 2017 11:11:54 GMT

have used the above code and it was working. Pls try and let me know