Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
sridhar_sigired
Creator
Creator

Values on data point

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.

3 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

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

Year = 2017

Capture.PNG

sridhar_sigired
Creator
Creator
Author

Thank you Sunny and Anil.