Qlik Community

Healthcare User Group

Announcements
Submit your remarkable customer story for the Global Transformation Awards at QlikWorld Denver 2022. SUBMIT A STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
emillanh
Explorer II
Explorer II

How to show a total and percent of total in a table

Hello, 

I'm trying to create create the following  using a table in qlik sense:

Patient ClassYesterdayMTDYTD
Inpatient 44132312229
Observation84947240
Total 52181719469
Observation%15.38%27.19%37.19%

 

The total is part of the table, but how do can i added the "Observation%" at the both of the table or is even possible? 

Thank you

 

3 Replies
Jihad99
Contributor II
Contributor II

Hello,

Can you please be more precise and clear about your inquiry? I wasn't able to understand you requirements.

Thanks,

emillanh
Explorer II
Explorer II
Author

I'm trying to get a "percent to Total" under the total column in a table. So, I want to see the %Observation admissions to total admission under each column under the total admissions.

 

Kenneth897
Contributor
Contributor

Hello,

I think Oleg's solution should work:

 

Create a chart with two dimensions, [Job Level] and Gender

 

As expression, use

=Count(ID) / Count(TOTAL<[Job Level]> ID)

 

I assume you have distinct IDs in the ID column, so you don't need to use explicitly a count distinct.

 

If you still have issues, could you describe what exactly you have done and what you see (and maybe what you expect to see)?