Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
zturaiki
Contributor III
Contributor III

selected date in set analysis

Good Afternoon ,

I need help in this Scenario :

I have the following rwo data ...

Patient File No.Cash IPDCash OPDInsurance IPDInsurance OPDPackage IPDPackage OPDTransaction
  Month
Transaction YearCharge MonthCharge Year
KK002231356 17201272012
KK002231357 17201272012
KK002233498 17201272012
KK0022335741 1 117201272012
KK002225181 1 1 6201272012
KK0022251811 111 7201262012
KK0022289331 1 117201262012
KK0022271501 1 117201262012
KK002228078 6201262012
KK0022381961 1 117201272012
KK00222892311111 7201272012
KK0022289231 11 7201262012

I would like it to be present as following :

YearMonthCash IPDCash OPDInsurance IPDInsurance OPDPackage IPDPackage OPD
201273891769
20126410600

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

3 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
zturaiki
Contributor III
Contributor III
Author

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

CELAMBARASAN
Partner - Champion
Partner - Champion

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