Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kylealpaugh
Contributor
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
sunny_talwar

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

View solution in original post

1 Reply
sunny_talwar

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

View solution in original post