topic Values on data point in QlikView

Values on data point

sridhar_sigired — Wed, 22 Mar 2017 11:31:06 GMT

Hi All,

In chart, we have option "Values on data point" in expression tab which shown values for each dimension.

Is there any chance we can display these values for specific dimensions?

I have two dimensions with one expression. Example

Data: Jan 2015 to This month

Chart: Line chart

Dim: Month and Year

Exp: Sum(Sales)

Now, 3 Lines shows 2015,2016 and 2017 from Jan-Dec as first dimension.

Can we show values only for 2017 line? Is it possible?

Thank you.

Anil_Babu_Samineni — Wed, 22 Mar 2017 11:40:46 GMT

May be set in expression like expand + and then write this condition and remind you may be UN-check value on data points on Expression point.

If(Year = '2017', 1, Sum(Sales))

sunny_talwar — Wed, 22 Mar 2017 11:41:12 GMT

May be use an if statement to show the values for year 2017 under Show Value on the expressions tab

Year = 2017

sridhar_sigired — Thu, 23 Mar 2017 02:03:30 GMT

Thank you Sunny and Anil.