topic Re: How to remove the total in QlikView

How to remove the total

Mon, 02 Mar 2015 14:00:25 GMT

There are 2 measurements (good and bads). The count of good is 600 and the total of bad is 7826 and I only want this two numbers. How can I remove the total 8429 number form the chart?

If possible the position of the 7826 (bads) should be on the position of the 8429 (which is the total).

Re: How to remove the total

ThornOfCrowns — Mon, 02 Mar 2015 14:05:02 GMT

Do you have show values on data points ticked?

Re: How to remove the total

Mon, 02 Mar 2015 14:06:00 GMT

Pedro, could you post the expressions options like show values on data points etc.?

That way we could help you better...

Re: How to remove the total

jpenuliar — Mon, 02 Mar 2015 14:06:12 GMT

Hi,

Have you tried Ticking the "Plot values Inside segments?"

Re: How to remove the total

sunny_talwar — Mon, 02 Mar 2015 14:15:12 GMT

Just as Jonathan Penuliar mentioned, put a tick mark on 'Plot Values Inside Segments' within the Presentation tab of Chart Properties.

Best,

Re: How to remove the total

Mon, 02 Mar 2015 14:33:01 GMT

I tried, but it doesnt remove the total value.

Re: How to remove the total

Mon, 02 Mar 2015 14:33:52 GMT

I post the expressions.

Re: How to remove the total

Mon, 02 Mar 2015 14:35:35 GMT

Yes, I do. And I can add or remove those values from the measurements, however I dont know how to remove the total value (which is equal to good+bad)

Re: How to remove the total

sunny_talwar — Mon, 02 Mar 2015 14:36:35 GMT

In the image you just posted, the expressions itself are not visible, Only the labels are visible. Can you copy paste the expressions you are using (instead of posting a image)?

Best,

Re: How to remove the total

Mon, 02 Mar 2015 14:41:35 GMT

Count({$<Result={"Bads"}>}Dia)

Count({$<Result={"Good"}>}Dia)

These are expressions I am using.

Re: How to remove the total

sunny_talwar — Mon, 02 Mar 2015 14:53:40 GMT

Please find attached. Hopefully this will help.

This is what you have:

This is what you want?

Best,

Re: How to remove the total

jpenuliar — Mon, 02 Mar 2015 14:54:37 GMT

It could be a Ref Line or Text in Chart in disguise

Re: How to remove the total

jpenuliar — Mon, 02 Mar 2015 14:56:03 GMT

If your chart was cloned from somewhere, a big chance some properties you are not aware of are also in it.

Try creating a new chart and start adding your expressions

Re: How to remove the total

Mon, 02 Mar 2015 14:58:42 GMT

I manage to put both values I want. I selected on both "text on axis". Someone know where I can put both values on the top?

Re: How to remove the total

Mon, 02 Mar 2015 15:02:51 GMT

I had to select "text on axis" for both. However now I dont know how to put the value on the top? The value "Good" with orange colour I want to put on the top of the bar.

Do you know how I can do it?

Re: How to remove the total

Mon, 02 Mar 2015 15:04:26 GMT

I want the secound. I manage to put the values but where can I define their positions?

My qlikview is not licensed, therefore I cant open your qvw.

Re: How to remove the total

sunny_talwar — Mon, 02 Mar 2015 15:07:08 GMT

Is the second image what you want the chart to look like?

Best,

Re: How to remove the total

sunny_talwar — Mon, 02 Mar 2015 15:08:41 GMT

If yes, then this is what I did: Expression tab:

Presentation Tab:

HTH

Best,

Re: How to remove the total

Mon, 02 Mar 2015 15:12:43 GMT

It is smilar to the second image, however I want the value to be on the top of the graph and not on the midle. Do you know where I can change it?

Thanks for the help!

Re: How to remove the total

sunny_talwar — Mon, 02 Mar 2015 15:19:03 GMT

Is this what you want?

Best,