Help me with this set expression

[#1]

Hi There,

I have a calculated dimension in table chart as follows.

=aggr(count(VISIT_MAIN),DRG_BL_VALUE)

In need to include a condition in that dimension to restrict it to those Discharge_Date with values only between the two calender object selections for start date and end date (vDMin and vDMax respectively)

That is, in the above aggr expression, I have to include this condition

Discharge_Date>=vDMin and Discharge_Date<=vDMax

I had given like this : =aggr(count( ( {$<Discharge_Date={">=$(vDMin)<=$(vDMax)"}>} VISIT_MAIN),DRG_BL_VALUE) , but it was not helpful.

Please help me with this.

Thanks

Sircute

[MayilVahanan]

HI

Try like this

=aggr(count( ( {$<Discharge_Date={">=$(=vDMin)<=$(=vDMax)"}>} VISIT_MAIN),DRG_BL_VALUE)

[#3]

Hi Mayil Vahanan,

That did not work

[MayilVahanan]

HI

Can you provide a sample?

[#5]

Hello Mayil

I have created a sample scenario here.

Please find the attached excel sheet  (source) and qlikview file

[Gysbert_Wassenaar · Accepted solution]

Try this:

=Aggr(Count({$<Discharge_Date={">=$(=date(vDMin,'M/D/YYYY'))<=$(=date(vDMax,'M/D/YYYY'))"}>} VISIT_MAIN),DRG_BL_VALUE)

[#7]

Gysbert,

That helped

So, it was all beacuse of the date format mismatch !!!

Thanks a lot !

Need one more help.. In the main dashboard which I am doing at the client side (which i cannot share here) , is in qv 11. The calendar object in there has months and years displayed in a different font. I donot know where to change this.

Can you tell me where should I go and change this font for month and year in calender object ?