To hide value on datapoints in Block chart

[Anonymous]

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

[kaushiknsolanki]

Hi,

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

Regards,

Kaushik Solanki

[Anonymous]

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.

[malini_qlikview]

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

[tamilarasu]

Hi Leni,

You can try this as calculated dimension.

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

[Digvijay_Singh · Accepted solution]

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

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

[Anonymous]

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

[Anonymous]

Thank you Digvijay, it worked

[Anonymous]

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