topic Re: dimension to show sum in QlikView

dimension to show sum

rcorcoran — Tue, 08 Jul 2014 11:47:45 GMT

I know this is pribably very bad coding but I am looking to show in a table Discharges 3 as Day case Discharges 5 as inpatient discharges which it does but then i want it to show a sum of Discharges 3,4 and 5 as Outpatients.

I have the following to show the first two but don't know how to add in the sum as outpatients

=If(Discharges=3, 'Day Case', If(Discharges=5, 'Inpatient Discharges',null()))

Any help would be great

Thanks

Re: dimension to show sum

tresB — Tue, 08 Jul 2014 11:52:21 GMT

May be like:

In the dimension limit tab, enable Show total and put the label 'Outpatients'.

Re: dimension to show sum

Gysbert_Wassenaar — Tue, 08 Jul 2014 11:53:22 GMT

If you're talking about a chart expression you can try sum({<Discharges={3,4,5}>}amount) or perhaps count({<Discharges={3,4,5}>} distinct PatientID).