Solved: How to create filter in expression correctly? - Qlik Community

mrichman · ‎2018-06-01

Hi Community,

I have a filed which I would like to implement within a pivot table, however it is not working properly. Do you guys maybe have an idea?

[Product Category] = ('TV','Radio','Aircon')

Thanks in advance.

Anil_Babu_Samineni · ‎2018-06-02

Not understand your request- Perhaps this?

{< [Product Category] = {'TV','Radio','Aircon'} >}

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

MarcoWedel · ‎2018-06-01

please post some sample data and your expected result.

Anil_Babu_Samineni · ‎2018-06-02

Not understand your request- Perhaps this?

{< [Product Category] = {'TV','Radio','Aircon'} >}

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Chanty4u · ‎2018-06-02

try

sum({< [Product Category] = {'TV','Radio','Aircon'} >}sales)