Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
mrichman
Contributor II

How to create filter in expression correctly?

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.

1 Solution

Accepted Solutions
Highlighted

Re: How to create filter in expression correctly?

Not understand your request- Perhaps this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
Highlighted

Re: How to create filter in expression correctly?

please post some sample data and your expected result.

Highlighted

Re: How to create filter in expression correctly?

Not understand your request- Perhaps this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
Chanty4u
Esteemed Contributor III

Re: How to create filter in expression correctly?

try

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