table should show filtered values based on 2nd dimension restriction in qliksense

[su88rao]

Hi All,

I have a table where i am trying to populate the values fetching it from database.

have 2 dimensions (say: category and brand). have multiple measures (for eg: avg count of prdoductid)

my requirement is :

complete table should show the values only if the count of productid is greater than or equal to 5 (productid >=5), based on the second dimension (brand).

I have tried limitation option available in qliksense with giving expression in the calculated field. also tried calculated expression in the data handling tab. but not successful. 

Can anybody help me out on 

Thanks and regards

Suraj Rao