Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Re: How to get count for a group people age 2-3 by a dynamic date?

This is a search string which either gives a true or a false. This search string is checked for each PatientID and if it returns false, it is excluded. If it returns true, it is included. To see what all is included.... create a new straight table object and add patientID as dimension and use this as expression

=Age(Num(v_selectedDate), Only({<VisitDate = {""$(='>=' & Date(v_selectedDate3YearsAgo) & '<=' & Date(v_selectedDate))""}, YearMonth>}DOB)) >= 50 and

  Age(Num(v_selectedDate), Only({<VisitDate = {""$(='>=' & Date(v_selectedDate3YearsAgo) & '<=' & Date(v_selectedDate))""}, YearMonth>}DOB)) <= 55

Whereever you see -1, those patient IDs are included in your expression.

Does that make sense?

baylor2016
Contributor

Re: How to get count for a group people age 2-3 by a dynamic date?

Great. I understand now. You are genius. Thank you for your helps as always.

Re: How to get count for a group people age 2-3 by a dynamic date?

No problem at all

baylor2016
Contributor

Re: How to get count for a group people age 2-3 by a dynamic date?

Hi Sunny,

I posted another question - show the calculated data points in the charts?  I think you will be able to help. Here is the link.

How to show these datapoints in the chart?

Thanks

Longmatch