Discussion board where members can get started with QlikView.
I have the above Data and need to get like below
the requirement is for each A Is_slipped is 'Y' when C is yes for all B and Is_slipped is 'N' when C is no for all B and Is_slipped is 'Partial' when C is either yes or no for all B
(ooxml, no labels, table is Sheet1);
Sum(if(C='yes',1)) as Y,
sum(if(C='no',1)) as N
Group by A;
Sum(if(C=0,1)) as dummy,
if(Y=0,'No',if(N=0,'Yes','Partial')) as is_slipped
But throwing error as "Invalid Expression". Please suggest.
The following given me the answer.. thank you
(ooxml, embedded labels, table is Sheet1);
if(sum(if(not isNull(B),1))=sum(if(C='yes',1)),'yes', if(sum(if(not isNull(B),1))=sum(if(C='no',1)),'No','Partial')) as is_slipped
View solution in original post