Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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()>}
My version is 10sr3
My aim is to show sales target for sales reps without effected by other filters
When i select a sales rep it shold be work
But other filters from other taps should not effect it
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)