Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Pivot subtotal by dimensions

How do I get subtotals of sub-dimensions in a pivot table? I have used the 'Show Totals' on all the dimensions, but I need sub-totals by category. Excel attached.

Dimensions:

  1. Charges_region
  2. Charges_Location_Name
  3. If(match(Charges_CPT_Rollup,'New Clinical Patients','Established Clinical Patients','Excisions','Mohs Surgery'),Charges_CPT_Rollup)

Expressions:

  • sum({$<Charges_CPT_KeyStatReport={'Y'},Charges_Department={'Clinical','Surgery','Phototherapy','*Unmapped*'}>}quantity)

Thank you.

Tags (1)
5 Replies
Highlighted

Re: Pivot subtotal by dimensions

Is your third dimension category? May be enable the sub-total for only your third dimension and disable them for all else?

Highlighted
Not applicable

Re: Pivot subtotal by dimensions

Hi Sunny - I tried enabling and disabling diff combos for the three dimensions and that doesn't seem to get me what I need. Qlik only gives me a top line total, but doesn't provide a total for each of the New Patients, Established Patients, Repairs, Surgery categories that I need. Should I be using aggr function on this? Thanks.

Highlighted
Partner
Partner

Re: Pivot subtotal by dimensions

Enable Show total to the dimension for which you want to display total.

Highlighted
Creator III
Creator III

Re: Pivot subtotal by dimensions

Enable subtotal for Category only and disable it for other dimensions.

Highlighted
Not applicable

Re: Pivot subtotal by dimensions

Try this:

sum({$<Charges_CPT_KeyStatReport={'Y'},Charges_Department={'Clinical','Surgery','Phototherapy','*Unmapped*'}>} total <Charges_Location_Name> quantity)