Help filtering an expression

[Anonymous]

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!

[sunny_talwar · Accepted solution]

Try this

Dimension

Car_model

Expression

Sum({<[car_color] = {'Black'}>}Sales)

[Anonymous]

Sunny,

That did it!  Thank you so much!!