topic Re: How can i effect a chart just by 1 filter? in QlikView

How can i effect a chart just by 1 filter?

Mon, 01 Aug 2011 21:18:43 GMT

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?

Re: How can i effect a chart just by 1 filter?

johnw — Mon, 01 Aug 2011 22:01:05 GMT

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()>}

How can i effect a chart just by 1 filter?

Mon, 01 Aug 2011 22:13:06 GMT

My version is 10sr3

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

How can i effect a chart just by 1 filter?

Mon, 01 Aug 2011 22:18:39 GMT

When i select a sales rep it shold be work

But other filters from other taps should not effect it

Re: How can i effect a chart just by 1 filter?

johnw — Mon, 01 Aug 2011 22:27:45 GMT

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)