Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Hi,Iam using a straight table , and i need to show only sub-totals in '%' for your reference please go thorough the images below.

1.png2.png3.png

9 Replies
sunny_talwar

You can use the concept of Dimensionality() to do this. Look at the following Blog by Robert Mika: How to use - Dimensionality()

engishfaque
Specialist III
Specialist III

Dear Naresh,

Expression1: Total Sales % = Sum(SalesField) / Sum(TOTAL SalesField)

Expression2: % Sales by Country = Sum(SalesField) / Sum(TOTAL<Country_Field> SalesField)

Kind regards,

Ishfaque Ahmed

nareshthavidishetty
Creator III
Creator III
Author

Hi,

My sales field contains expression

Closing Rate=[invoice count]/[Adjusted Tariff]

Can you please help me how to write the expression.

sunny_talwar

Not sure, but may be this:

If(Dimensionality() = 0, Num([invoice count]/[Adjusted Tariff], '#,##0.0%'), Num([invoice count]/[Adjusted Tariff], '#,##0'))

nareshthavidishetty
Creator III
Creator III
Author

Hi,

It is not working,it gives me same output.

settu_periasamy
Master III
Master III

Hi Naresh,

Did you try with sunindia Expression With the Total Mode as Expression Total ?

sunny_talwar

I think you mean formatting as Expression's default, right?

Capture.PNG

settu_periasamy
Master III
Master III

This One

Capture.JPG

sunny_talwar

I guess we need both to be Expression default