# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Partner - Contributor III

## Require datapoints only at start and end in Line chart

REQUIREMENT

I am working on qlik sense line chart . I want the line chart to show only static start and end point pop up as shown in the below screenshot.

Current Status

Currently as shown below, qliksense allow all the Mockup/Data points for all the months, but I don't want in that way. Can any body help me on this. i want data point at start and end values only .Do we need to download any extension to work on this or this can be handled in qliksense desktop itself.

1 Solution

Accepted Solutions
MVP

Create a combined chart:

Expression 1 : as line :

YourExpression

Expression2:as Points:

if(YourExpressionforMinandMax=0,null(),YourExpressionforMinandMax)

Per Analogy:

Original Line chart:

dim : Num

Expression : sum(Expression1):

New chart: combined chart:

dim:

Num

Expression1: Sum(Expression1)

Expression 2:

if(Sum({<Num={'26','1'}>}Expression1)=0,Null(),Sum({<Num={'26','1'}>}Expression1))

Result:

3 Replies
Champion

Hi,

maybe omarbensalem‌ have some tips here about extensions or something ?

MVP

Create a combined chart:

Expression 1 : as line :

YourExpression

Expression2:as Points:

if(YourExpressionforMinandMax=0,null(),YourExpressionforMinandMax)

Per Analogy:

Original Line chart:

dim : Num

Expression : sum(Expression1):

New chart: combined chart:

dim:

Num

Expression1: Sum(Expression1)

Expression 2:

if(Sum({<Num={'26','1'}>}Expression1)=0,Null(),Sum({<Num={'26','1'}>}Expression1))

Result:

Partner - Contributor III
Author

Thank You for your Response .

Tags
Community Browser