Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
New Contributor III

Development

ABC
1ayes
1byes
1cyes
2dno
2eno
3fyes
3gno
3hyes
3ino
4jyes

I have the above Data and need to get like below

 

ABCIs_slipped
1ayesY
1byesY
1cyesY
2dnon
2enon
3fyespartial
3gnopartial
3hyespartial
3inopartial
4jyesY

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

Test:

LOAD A,

     B,

     C

FROM

(ooxml, no labels, table is Sheet1);

left join(Test)

LOAD A,

  Sum(if(C='yes',1)) as Y,

  sum(if(C='no',1)) as N

  

Resident Test

Group by A;

Left Join(Test)

LOAD A,

  Sum(if(C=0,1)) as dummy,

  if(Y=0,'No',if(N=0,'Yes','Partial')) as is_slipped

Resident Test

Group by A;

But throwing error as "Invalid Expression". Please suggest.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
New Contributor III

Re: Development

The following given me the answer.. thank you

Test:

LOAD A,

     B,

     C

FROM

(ooxml, embedded labels, table is Sheet1);

Left Join(Test)

LOAD A,

  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

Resident Test

Group by A;

View solution in original post

1 Reply
Highlighted
New Contributor III

Re: Development

The following given me the answer.. thank you

Test:

LOAD A,

     B,

     C

FROM

(ooxml, embedded labels, table is Sheet1);

Left Join(Test)

LOAD A,

  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

Resident Test

Group by A;

View solution in original post