topic Set Analysis. in QlikView

Set Analysis.

srinivasa1 — Fri, 28 Jan 2011 06:58:46 GMT

Hi,

i need to calulcate Satrs count for bellow

STARS	LOB	ProductTypeID
COL	MC	NOT PPO
CMC	MC	All

in this if stars=col and Lob=MC and ProductTypeID <>PPO. this applicable only for col rest of cols there will not be any product type condtion. i need to add this logic in bellow experssion

=count({<Der_Assigned_Reviewer={'QM', 'MRA', 'OUTCOMES', 'Unassigned'},MeasureID={'COL','CMC','CBP','CDC2B','CDC2E','CDC2H','CDC2L','CDC2N'}, LOB={"MC"}>} distinct MemberGenKey & MeasureID)

can any pls guide me how can vlidate product typeId only for COL.

Thx in adavance.

Srini

Set Analysis.

Fri, 28 Jan 2011 07:17:43 GMT

count({<Der_Assigned_Reviewer={'QM', 'MRA', 'OUTCOMES', 'Unassigned'},MeasureID={'COL','CMC','CBP','CDC2B','CDC2E','CDC2H','CDC2L','CDC2N'}, LOB={"MC"}, STARS={"COL"},ProductTypeID-={'PPO'}>} distinct MemberGenKey & MeasureID)

In the above expression only 2 conditions have been included, one is Stars=col and Producttypeid <> PPO. This should mostly work. Pls chk for single quotes/double quotes accordingly in the new conditions written above.

Set Analysis.

srinivasa1 — Fri, 28 Jan 2011 07:23:25 GMT

Hi thx for quick reply. but it will for for other cols i mean i need to search inside MeasureID=COL if MeasureID=COL then i need to check for ProductTypeID<>{'PPO'}>.

thx

Set Analysis.

suniljain — Fri, 28 Jan 2011 08:00:49 GMT

Dear Srinivas,

pls try to implement this scenario at script level. it will reduce complexity.