Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

dimension to show sum

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

2 Replies
Highlighted
MVP
MVP

Re: dimension to show sum

May be like:

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: dimension to show sum

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).


talk is cheap, supply exceeds demand