selected date in set analysis

zturaiki — Mon, 09 Sep 2013 10:52:18 GMT

Good Afternoon ,

I need help in this Scenario :

I have the following rwo data ...

I would like it to be present as following :

Cash IPD = Count ({<Cash IPD={'1'}>}Patient File No)

Cash OPD = Count ({<Cash OPD={'1'}>}Patient File No)

Insurance IPD = Count ({<Insurance IPD={'1'}>}Patient File No)

Insurance OPD = Count ({<Insurance OPD={'1'}>}Patient File No)

Package IPD = Count ({<Package IPD={'1'}>}Patient File No)

Package OPD = Count ({<Package OPD={'1'}>}Patient File No)

the problem is on the date :

the Cash IPD and Cash OPD - it base on the charge Month and Charge Year

the Insurance(IPD/OPD) and the Package --- it base o the Transaction Month and Transaction Year

in my dashboard ,, i want the user to select the year and the month one time ,

attached is a simble data on excel

Re: selected date in set analysis

Gysbert_Wassenaar — Mon, 09 Sep 2013 11:15:09 GMT

See attached qvw.

zturaiki — Wed, 25 Sep 2013 12:30:03 GMT

Thank You , solution work but it slow down the load of the Data model .. i am looking for faster solution

CELAMBARASAN — Wed, 25 Sep 2013 12:35:44 GMT

Hi,

G Wassenaar solution will be faster. How you are saying that it slow down the load. Actually Sum is faster than count.

Could please explain it better? I dont understand why it is slow