Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

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

Re: Require datapoints only at start and end in Line chart

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
Esteemed Contributor

Re: Require datapoints only at start and end in Line chart

Hi,

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

Partner
Partner

Re: Require datapoints only at start and end in Line chart

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

Partner
Partner

Re: Require datapoints only at start and end in Line chart

Thank You for your Response .