Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
baylor2016
Creator
Creator

The date varible in set analysis not working.

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:

1.

=count(

{<

FLAG_DM={1}

,YEARSSINCELASTVISIT={"<4"}

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

>}

DISTINCT PAT_ID

)

2.

=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

1 Solution

Accepted Solutions
parimikittu
Creator II
Creator II

4 Replies
parimikittu
Creator II
Creator II

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

baylor2016
Creator
Creator
Author

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

parimikittu
Creator II
Creator II

Untitled.png

parimikittu
Creator II
Creator II

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