If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
Accepted Solutions
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:
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:
