Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

kylealpaugh
New Contributor

filter on field used in set analysis

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

1 Solution

Accepted Solutions

Re: filter on field used in set analysis

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

1 Reply

Re: filter on field used in set analysis

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