topic Re: Filter is not working in QlikView

Filter is not working

kfahri342 — Sat, 16 Nov 2024 04:30:35 GMT

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

Re: Filter is not working

sunny_talwar — Fri, 08 Feb 2019 14:38:43 GMT

Try this

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

Re: Filter is not working

kfahri342 — Fri, 08 Feb 2019 14:40:51 GMT

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

Re: Filter is not working

sunny_talwar — Fri, 08 Feb 2019 14:46:12 GMT

Check here

Implicit Set Operators