Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

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

Year = 2017

Capture.PNG

Highlighted
Creator
Creator

Thank you Sunny and Anil.