Restricting Filters on a exp.

[mohitd910]

Dear all,

This is  my Exp. I want to restrict it for all filters which is present in the current sheet.

Count(Distinct {1<Date_Date={"$(=vToday)"}, Flag={'visits day & Type'}>} IH_EMR_PAT_ID )

stalwar1‌

mrkachhiaimp‌

mayilvahanan‌

mto‌

Regards,

Mohit Dahiya

[MK_QSL]

vToday=Date(Max({1}Date_Date),'DD/MM/YYYY')

Your variable name is misleading ...

It should be vMaxDate.. !!!

[jagan]

Hi Mohit,

If your variable value changes then your expression value also changes.  This is why you are getting different values when you are selecting even you give 1 in the expression.

Regards,

Jagan.

[mohitd910]

No issue that can be any thing i have also vMaxDate it should work.

[MK_QSL]

vToday=Date(Max({1}Date_Date),'DD/MM/YYYY')

This variable is having {1} which is missing in your expression..

[MK_QSL]

I think jagan has given answer before me.. so you should have marked his answer correct (and my one helpful if you need to mark more than one answers)

Please make sure to mark correct/helpful answer wisely which will encourage other members to reply your questions.

Thanks

MK

[mohitd910]

Sry Jagan Bhai i didn't see

[mohitd910]

Yes thanks sir Sry @jagan bhai. actually there were 3-4 replies courser directly go to  last answer