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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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