Hi, I'm new to Qlik Sense so forgive me if this has been asked.
I have a line chart with Term Code and Gender as my Dimensions and Count(Enrollment) as my Measure. I have two lines in my Line Chart 1 for Females and 1 for Males. I would like a 3rd line that has the total of both the Male and the Female Enrollment. I've reviewed some videos and gather that it is a calculation but I'm not doing something right.
When I create the synthethic dimension and use it I loose the individual lines for Male and Female and it changes the graph to just the total but I see entries in the legend for Male, Female and Total. Not sure what I'm doing wrong.
Use only Term Code as dimension and three expressions:
For clarity I'd choose Line as Presentation instead of Area.
If you don't see the Female and Male lines then the set expression is probably returning an empty set. Make sure to use exact case sensitive field names and values. Female, FEMALE and female are three different values. Gender, GENDER and gender are three different fields.