Hi,
I've got some data with a shape like:
| Date | Category | ID |
---------------------------------
I can make a line plot what shows the weekly count of events. I'd like to split this line by the values of the Category Column. These are categories like "Blue" and "Red". So instead of one line for all the data, I'd have two.
The help documentation I've found seems to suggest i need to manually create separate measures for each category I want to have a separate line for - am I reading that right? What if I don't know what the categories are going to be in advance? Like sometimes "Green" might be included, but sometimes not.
I'm used to ggplot and plotly and matplotlib where coloring shapes by some category takes just an extra keyword or something - so is there a built-in way to do this in Qlik that I've missed?
Thanks!
