Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
That's helpful, but I can't seem to get it to work in QlikSense. Any advice?
If possible attach your app here.
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.
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
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