topic Re: how to remove totals label in QlikView

how to remove totals label

sannidhikumar — Wed, 25 Nov 2020 16:16:04 GMT

hi ALL,

how to remove multiple total lables from top ..

thanks ,

Re: how to remove totals label

surendraj — Sat, 21 Jan 2017 09:34:06 GMT

Hi,

Based on your requirement

you can use either

properties-->expressions

In presentation tab

hope this may help you!!

--surendra

Re: how to remove totals label

girirajsinh — Sat, 21 Jan 2017 09:53:19 GMT

Hello Pradeep,

You are getting multiple Total label because all measures are together.

In case you want to keep the Total value visible but just hiding the Label

You can put Blank below in Presentation tab.

Re: how to remove totals label

sannidhikumar — Sat, 21 Jan 2017 17:51:51 GMT

hi Giriraj ,

i tried but i need atleast one Total to be visible at the top how can i achieve it any suggestions.

thanks ,

Re: how to remove totals label

surendraj — Sat, 21 Jan 2017 17:58:17 GMT

Hi Pradeep,

You can use

Properties-->expressions-->Total mode--->No totals for all the expressions you used expect for one expression which you need to be show total for that.

for that expression we can enable-->totals on first row.

--Surendra

Re: how to remove totals label

girirajsinh — Sat, 21 Jan 2017 22:00:26 GMT

Do you want one Total Value to be visible OR one Total Label visible?

Re: how to remove totals label

sannidhikumar — Sun, 22 Jan 2017 10:24:19 GMT

yes total label one to be visible on top corner

Re: how to remove totals label

girirajsinh — Sun, 22 Jan 2017 12:50:57 GMT

Hi Pradeep

You can do it as following

Make following settings for your first dimension i.e. CustNo

On expression tab

On Presentation tab

Re: how to remove totals label

HirisH_V7 — Sun, 22 Jan 2017 13:19:25 GMT

Hello,

Do some thing like this,

Keep no totals at expression for all the expressions &

At Presentation -> Multiline Settings -> Wrap Header text - > 3 or as you require.

There at free space, place a text object as you require, placing your expression code in it.

PFA,

Hirish

Re: how to remove totals label

sannidhikumar — Mon, 23 Jan 2017 10:38:19 GMT

hi Hirish ,

still i am not able to solve that any other options let me know ?

thanks ,

Re: how to remove totals label

girirajsinh — Mon, 23 Jan 2017 10:46:54 GMT

wasn't that you want ? Label should appear one time and total should multiple time.

Could you check what I suggested lately ie Enabling Show Total from Dimension Limit tab and seleting "No Total" from Expression tab ?. Please check my last post. It is shown there.

Re: how to remove totals label

HirisH_V7 — Mon, 23 Jan 2017 11:45:52 GMT

Hi,

Can you share a sample app with your requirement clearly elaborated!!!