Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Discussion Board for collaboration related to QlikView App Development.

- Qlik Community
- :
- All Forums
- :
- QlikView App Dev
- :
- Development

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Anonymous

Not applicable

2016-06-15
08:06 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Development

A | B | C |

1 | a | yes |

1 | b | yes |

1 | c | yes |

2 | d | no |

2 | e | no |

3 | f | yes |

3 | g | no |

3 | h | yes |

3 | i | no |

4 | j | yes |

I have the above Data and need to get like below

A | B | C | Is_slipped |

1 | a | yes | Y |

1 | b | yes | Y |

1 | c | yes | Y |

2 | d | no | n |

2 | e | no | n |

3 | f | yes | partial |

3 | g | no | partial |

3 | h | yes | partial |

3 | i | no | partial |

4 | j | yes | Y |

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.

154 Views

1 Solution

Accepted Solutions

Anonymous

Not applicable

2016-06-15
08:55 AM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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;

112 Views

1 Reply

Anonymous

Not applicable

2016-06-15
08:55 AM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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;

113 Views