AND operator in set analysis

[Anonymous]

Hi all,

     I have a pivot table as in the image below, but there's one exception only for AMS (row dim), when the role = 'Guarantee' (the role is not in the pivot), so I should remove those from the "QD" count. But how do I include that in the set analysis to say "where region<>'AMS' AND role<>'Gaurantee' " without loosing the whole AMS row?

=Count({<[Report Date]={"$(MaxDate)"}>} [StatusID])

[Anonymous]

Thx Jaime, but that will remove all AMS and all Guarantee

[stigchel]

Hi Oscar, maybe you can use the * intersection operator, something like below.(and maybe E instead of P)

=Count({<[Report Date]={"$(MaxDate)"},[Id]=P({1<Region={'<>AMS'}>})*p({1<Role={'<>Guarantee'}>} [Id])>} [StatusID])

[aveeeeeee7en]

See this:

http://community.qlik.com/message/406104

http://community.qlik.com/thread/126883

Regards

Aviral Nag