Skip to main content

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 
Search instead for 
Did you mean: 
rajumachra
Partner - Contributor III
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.

qlikissue1.png


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.

qlikissue2.png

1 Solution

Accepted Solutions
OmarBenSalem

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

Capture.PNG

New chart: combined chart:

dim:

Num

Expression1: Sum(Expression1)

Capture.PNG

Expression 2:

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

Capture.PNG

Result:

Capture.PNG

View solution in original post

3 Replies
YoussefBelloum
Champion
Champion

Hi,

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

OmarBenSalem

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

Capture.PNG

New chart: combined chart:

dim:

Num

Expression1: Sum(Expression1)

Capture.PNG

Expression 2:

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

Capture.PNG

Result:

Capture.PNG

rajumachra
Partner - Contributor III
Partner - Contributor III
Author

Thank You for your Response .