Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

More Format expression in a label questions

So i have an expression in a label that i have a problem with some formatting.

The label expression is this:

=Concat('% of Patients who died in Hospital - average =' & ' - ' & NUM(Avg(TOTAL AGGR(Count({<EndOfSpell={'Death'}>}[Unique ID])/Count([Unique ID]),[Admission Month/Year])),'0.00'))

Unfortunately the expression is a percentage and whilst the expression that this label is linked to i have been able to alter in the chart properties to change the number to a percentage there is no way of doing that in the label.

Any ideas?

This is what it currently looks like - i believe the average i'm trying to display would be around 16%

death.png

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Dont worry - worked it out.

Just added a % in the last section so it looks like this:

 

=Concat('% of Patients who died in Hospital - average =' & ' - ' & NUM(Avg(TOTAL AGGR(Count({<EndOfSpell={'Death'}>}[Unique ID])/Count([Unique ID]),[Admission Month/Year])),'0%'))

View solution in original post

1 Reply
Highlighted
Creator II
Creator II

Dont worry - worked it out.

Just added a % in the last section so it looks like this:

 

=Concat('% of Patients who died in Hospital - average =' & ' - ' & NUM(Avg(TOTAL AGGR(Count({<EndOfSpell={'Death'}>}[Unique ID])/Count([Unique ID]),[Admission Month/Year])),'0%'))

View solution in original post