filter on field used in set analysis

kylealpaugh — Wed, 25 Nov 2020 16:16:04 GMT

When i filter on a field that i use in set analysis it does not filter down it keeps the same value i was wondering if there was any fix to this problem.

Example

sum({1< [Customer]={'EBR*'}>}Sales)

There are multiple customers that start with EBR i want the chart to show all of them which it does but i also need to be able to filter down to see each one of them individually.

Is there any way to be able to do this

Thanks

Re: filter on field used in set analysis

sunny_talwar — Fri, 02 Nov 2018 18:45:07 GMT

Try this

Sum({1<[Customer] *= {"EBR*"}>}Sales)

Read about * here

Also, use double quotes instead of single quotes for search strings. Read here

Quotes in Set Analysis

topic filter on field used in set analysis in QlikView

filter on field used in set analysis

Re: filter on field used in set analysis