Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this
Dimension
Car_model
Expression
Sum({<[car_color] = {'Black'}>}Sales)
Try this
Dimension
Car_model
Expression
Sum({<[car_color] = {'Black'}>}Sales)
Sunny,
That did it! Thank you so much!!