topic Re: To hide value on datapoints in Block chart in QlikView

To hide value on datapoints in Block chart

Anonymous — Wed, 03 May 2017 11:09:33 GMT

Hi All,

I would like to hide the numbers showing in block chart for the first dimension alone.

In the above chart I would to hide the values with parenthesis for the first dimension alone. The value inside the chart should retain.

Is there a way to achieve the same?

Please share your thoughts.

Thanks in advance.

Regards,

Leni Balakrishnan

Re: To hide value on datapoints in Block chart

kaushiknsolanki — Wed, 03 May 2017 11:12:13 GMT

Hi,

Go to Chart Properties -> Presentation Tab -> Deselect "Show Numbers with Labels".

Regards,

Kaushik Solanki

Re: To hide value on datapoints in Block chart

Anonymous — Wed, 03 May 2017 12:02:53 GMT

Thank you for the response.

But it will hide the values in both the dimensions but I would like to hide value of first dimension alone not the second one.

Re: To hide value on datapoints in Block chart

malini_qlikview — Wed, 03 May 2017 15:46:59 GMT

Hi,

Please try the below

1. In presentation tab -- Disable "Show Numbers with Labels" (this will hide all dimension numbers)

2. In the dimensions list -- > for second dimension field - make it a calculated dimension, to include the expression along with the dimension

Eg: Dimension2 & ' ( ' & Aggr(Sum(Expression),Dimension2) & ' )'

Re: To hide value on datapoints in Block chart

tamilarasu — Wed, 03 May 2017 15:54:02 GMT

Hi Leni,

You can try this as calculated dimension.

=Dual('', [Dimension 1 Name])

Re: To hide value on datapoints in Block chart

Digvijay_Singh — Wed, 03 May 2017 16:02:22 GMT

I think we may need to include Dimension1 in Aggr to show correct values -

Dimension2 & ' ( ' & Aggr(Sum(Expression),Dimension1, Dimension2) & ' )'

Re: To hide value on datapoints in Block chart

Anonymous — Thu, 04 May 2017 06:33:53 GMT

Hi Malini,

Thank you for the solution.

As mentioned by Digvijay, I got correct value when I used the first dimension as well.

Thank you so much..

Regards,

Leni Balakrishnan

Re: To hide value on datapoints in Block chart

Anonymous — Thu, 04 May 2017 06:34:18 GMT

Thank you Digvijay, it worked

Re: To hide value on datapoints in Block chart

Anonymous — Thu, 04 May 2017 06:37:30 GMT

Hi Tamil,

Thank you for the solution.

Dual('',Dim1) hides the first dimension from the chart. But I would like to see the dimension value and not the expression value which comes in parenthesis.

Regards,

Leni Balakrishnan