Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Making a dotted line in a combo chart

I'm trying to make a combo chart with both solid and dotted lines for different measures in QlikSense. From poking around, I've gathered that the code for a dotted line is '<S2>' but I can't seem to figure out how to use it correctly. The formula I'm currently using is:

Count(If([AverageDays] < 5 AND ([Type] = 'Type1' OR 'Type2'), [CaseCode]))/Count(IF([Type] = 'Type1' OR 'Type2', [CaseCode]))

Thoughts on how I can include the '<S2>' in this to make it into a dotted line?

6 Replies
prabhu0505
Specialist
Specialist

This option is directly available.

In combo chart you have three choices for displaying metric - bars, line and marker.

Select Marker for the one which you wan to show as dotted line and choose appropriate symbol.

Not applicable
Author

That's helpful, but I can't seem to get it to work in QlikSense. Any advice?

prabhu0505
Specialist
Specialist

If possible attach your app here.

Not applicable
Author

I can't provide the whole app, but let me try to clarify with the expressions I'm trying to put into this combo chart.

Dimension (1):

Month

Measures (6):

Percentage1: Count(If([Attempts] < 5 AND ([Type] = 'Type1' OR 'Type2'), [AttemptCode]))/Count(IF([Type] = 'Type1' OR 'Type2', [AttemptCode])) -- this formula exists to give me a percent of attempts that are fewer than 5.

Percentage2: Sum([PercentageGoal])

Percentage3: Sum([PercentageMinimum])

Number1: Sum(ActualQuantity)


Number2: Sum(ProjectedQuantity)

Number3: Sum(MinimumQuantity)

I want the percentages to be represented by dotted or dashed lines.

r_wroblewski
Partner - Creator III
Partner - Creator III

Hi Daniel

I think the only way is to use marker (line) instead of line in qlik sense to simulate a dashed/dotted line, like Saravana already described. The option '<S1>' ~ '<S3>' can't be used to modify your line in qlik sense.


Please see attached pic

Community176012.PNG

But it's not really a dashed/dotted line, especially if your values differs a lot.

I think the only possibility to use a  real dashed/dotted line would be to use an extension or create it by yourself where you can modify the line style but until now you can't change it like in qlikview.

Best regards,

Ronny