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

[emillanh]

Hello, 

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

Patient Class	Yesterday	MTD	YTD
Inpatient	44	1323	12229
Observation	8	494	7240
Total	52	1817	19469
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

[Jihad99]

Hello,

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

Thanks,

[emillanh]

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]

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