Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can i effect a chart just by 1 filter?

There is some way for set analysis but it is difficult to exclude all filter. Can you help me if there is any easy script for my issue?

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

OK, then this might be the set you need:

{1<SalesRep=P()>}

So if you want the sum of sales for selected sales reps ignoring all other filters:

sum({1<SalesRep=P()>} Sales)

View solution in original post

4 Replies
johnw
Champion III
Champion III

You're trying to ignore all fields but one?  Depending on what version of QlikView you have and what you mean by "ignore", this set might work for you:

{1<MyField=P()>}

Not applicable
Author

My version is 10sr3

My aim is to show sales target for sales reps without effected by other filters

Not applicable
Author

When i select a sales rep it shold be work

But other filters from other taps should not effect it

johnw
Champion III
Champion III

OK, then this might be the set you need:

{1<SalesRep=P()>}

So if you want the sum of sales for selected sales reps ignoring all other filters:

sum({1<SalesRep=P()>} Sales)