Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

To hide value on datapoints in Block chart

Hi All,

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

blockchart.png

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Master III
Master III

Re: To hide value on datapoints in Block chart

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

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

View solution in original post

8 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: To hide value on datapoints in Block chart

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Creator III
Creator III

Re: To hide value on datapoints in Block chart

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.

Highlighted
Creator II
Creator II

Re: To hide value on datapoints in Block chart

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

Highlighted

Re: To hide value on datapoints in Block chart

Hi Leni,

You can try this as calculated dimension.

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

Highlighted
Master III
Master III

Re: To hide value on datapoints in Block chart

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

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

View solution in original post

Highlighted
Creator III
Creator III

Re: To hide value on datapoints in Block chart

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

Highlighted
Creator III
Creator III

Re: To hide value on datapoints in Block chart

Thank you Digvijay, it worked

Highlighted
Creator III
Creator III

Re: To hide value on datapoints in Block chart

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