Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Making a dotted line in a combo chart

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.

maximiliano_vel
Contributor III

Re: Making a dotted line in a combo chart

Not applicable

Re: Making a dotted line in a combo chart

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

prabhu0505
Valued Contributor

Re: Making a dotted line in a combo chart

If possible attach your app here.

Not applicable

Re: Making a dotted line in a combo chart

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

Re: Making a dotted line in a combo chart

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

Community Browser