2 Replies Latest reply: Feb 6, 2018 3:52 PM by Dawn Graese RSS

    Help filtering an expression

    Dawn Graese

      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!