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

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

Sub totals

Hi,i need to show only the sub totals in percentage,like image_1,but i got the result as image_2.

5.png       6.png

6 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

This screen shot is fundamentally useless. If you want help, you will need to provide a lot more information and preferably your qvw or a representative sample.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
senpradip007
Specialist III
Specialist III

Can you share sample qvw?

preminqlik
Specialist II
Specialist II

go to properties>>number >>mark "Expression default"

and make the following changes in your expression

if(dimensionality()=1, num(<Your Expression>,'##,##0.00'),num(<Your Expression>,'##,##0'))

preminqlik
Specialist II
Specialist II

for reference add another expression like below , to check value of dimensionality and then apply above mentioned method

=Dimensionality()

qlikviewwizard
Master II
Master II

Hi,

Can you share the sample doc to demonstrate your requirement?

Not applicable

PFA.

John