topic Re: Sub totals in QlikView

Sub totals

nareshthavidishetty — Thu, 03 Sep 2015 05:06:52 GMT

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

Re: Sub totals

jonathandienst — Thu, 03 Sep 2015 05:10:30 GMT

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.

Re: Sub totals

senpradip007 — Thu, 03 Sep 2015 05:12:00 GMT

Can you share sample qvw?

Re: Sub totals

preminqlik — Thu, 03 Sep 2015 05:16:43 GMT

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

Re: Sub totals

preminqlik — Thu, 03 Sep 2015 05:18:14 GMT

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

=Dimensionality()

Re: Sub totals

qlikviewwizard — Thu, 03 Sep 2015 05:25:01 GMT

Hi,

Can you share the sample doc to demonstrate your requirement?

Re: Sub totals

Thu, 03 Sep 2015 05:28:37 GMT

PFA.

John