Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rajumachra
New Contributor II

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

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

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 ?

OmarBenSalem
Esteemed Contributor

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

rajumachra
New Contributor II

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

Thank You for your Response .

Community Browser