I'm trying to build a bar chart where I have car_model as the dimension and sum of sales by month as the measure. I only want the chart to show the sum of sales where car_color = "Black"
For the car_model expression, my attempt at filtering to have only black cars included is below. The syntax appears to be correct, but Qlik says it's an "Invalid Dimension".
=count({$<[car_color]="Black">} Distinct car_model)
I understand that dimensions shouldn't have aggregate functions, so I tried taking out "count" and it still doesn't work. I also tried taking out distinct, but that didn't make a difference either.
Thank you for the help!
