Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
kfahri342
Contributor III
Contributor III

Filter is not working

Hi,

Unfortunately, the document I am working on is strictly private so I will be using a generic/made-up example to demonstrate my issue. I have two tables (1 x Pivot and 1 x Straight Table)

The pivot tables shows a summary table of how many purchases a consumer has made on a specific type of product. The expression is

Count({<[Type of Product]={ "Clothes", "Food*", "DIY"},
[Type of Consumer] ={"1"},
[Gender]={"*1"}>} Productid),

The Straight table uses the exact same expression but provides a breakdown of the types of Products the consumer has bought (e.g. Apples, Flowers etc.)

My issue is when I select Product Type = Food as a filter. Neither table seems to filter to this result only. The order of the columns and rows seem change, but the data doesn'tfilter.

Any ideas why?

Many Thanks

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

Try this

Count({<[Type of Product] *= { "Clothes", "Food*", "DIY"},
[Type of Consumer] = {"1"},
[Gender] = {"*1"}>} Productid),

View solution in original post

3 Replies
sunny_talwar

Try this

Count({<[Type of Product] *= { "Clothes", "Food*", "DIY"},
[Type of Consumer] = {"1"},
[Gender] = {"*1"}>} Productid),
kfahri342
Contributor III
Contributor III
Author

It worked. Thank you. Can you explain what the * does in this case?

sunny_talwar