Creating independant stages

renjithpl — Wed, 24 Mar 2010 07:23:31 GMT

I have two stages, In stage1 I want only Responsive Error which is the second last column of the below pivot table and in stage 2 I want both "Responsive Error" and "Relevancy Error" which is last column of pivot table. But when I tried the same data appears in both stages. How can I segregate? My formula for Responsive Error is =If("ReviewerRespCategory"<>"RespCatCode", 'Error') and for Relevancy Error is =If("ReviewerRelCatg"<>"RelCatCode", 'Error') .

DemoDocID	ReviewerRespCategory	RespCatCode	ReviewerPNW	PotenNWCode	ReviewerRelCatg	RelCatCode	Responsive Error	Relevancy Error
155438		1-Buying-				1-Securities	-	Error
178968						2-	-	Error
215629				abcd			Error	Error

topic Creating independant stages in QlikView

Creating independant stages