Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=Aggr(Count({$<Discharge_Date={">=$(=date(vDMin,'M/D/YYYY'))<=$(=date(vDMax,'M/D/YYYY'))"}>} VISIT_MAIN),DRG_BL_VALUE)
HI
Try like this
=aggr(count( ( {$<Discharge_Date={">=$(=vDMin)<=$(=vDMax)"}>} VISIT_MAIN),DRG_BL_VALUE)
Hi Mayil Vahanan,
That did not work
HI
Can you provide a sample?
Hello Mayil
I have created a sample scenario here.
Please find the attached excel sheet (source) and qlikview file
Try this:
=Aggr(Count({$<Discharge_Date={">=$(=date(vDMin,'M/D/YYYY'))<=$(=date(vDMax,'M/D/YYYY'))"}>} VISIT_MAIN),DRG_BL_VALUE)
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 ?