topic Re: Help me with this set expression in QlikView

Help me with this set expression

Thu, 06 Dec 2012 13:11:03 GMT

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

Re: Help me with this set expression

MayilVahanan — Thu, 06 Dec 2012 13:36:18 GMT

Try like this

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

Re: Help me with this set expression

Thu, 06 Dec 2012 13:54:07 GMT

Hi Mayil Vahanan,

That did not work

Re: Help me with this set expression

MayilVahanan — Thu, 06 Dec 2012 17:01:49 GMT

Can you provide a sample?

Re: Help me with this set expression

Fri, 07 Dec 2012 07:07:20 GMT

Hello Mayil

I have created a sample scenario here.

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

Re: Help me with this set expression

Gysbert_Wassenaar — Fri, 07 Dec 2012 07:40:13 GMT

Try this:

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

Re: Help me with this set expression

Fri, 07 Dec 2012 09:23:25 GMT

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 ?