topic SQL "Like" in QlikView in QlikView

Rounded Border

shumailh — Wed, 29 Jul 2009 23:51:43 GMT

Hi,

How can we get the rounded border or some extra features in table object in layout tab? as mention below:

I am getting 2nd snapshot.. [:S][:S]

Regards,
SHUMAIL HUSSAIN

SQL "Like" in QlikView

hector — Thu, 30 Jul 2009 00:07:48 GMT

Hi, you can use the function wildmatch(), with thw wildcards '*' for more than 1 character, or the '?' for one, this is an example script and table

t1:LOAD F1, if(wildmatch(F1,'sup*'),'True','False') as like_1, if(wildmatch(F1,'*sup'),'True','False') as like_2, if(wildmatch(F1,'*sup*'),'True','False') as like_3, if(wildmatch(F1,'?at?up'),'True','False') as like_4
INLINE [ F1 Sup sup superi Catsup Catzup];<table><tbody><tr> <th>F1 </th><th>like_1 </th><th>like_2 </th><th>like_3 </th><th>like_4</th></tr><tr> <td>Catsup </td><td>False </td><td>True </td><td>True </td><td>True</td></tr><tr> <td>Catzup </td><td>False </td><td>False </td><td>False </td><td>True</td></tr><tr> <td>Sup </td><td>True </td><td>True </td><td>True </td><td>False</td></tr><tr> <td>sup </td><td>True </td><td>True </td><td>True </td><td>False</td></tr><tr> <td>superi </td><td>True </td><td>False </td><td>True </td><td>False</td></tr></tbody></table>

I hope this can help u

Regards

Rounded Border

hector — Thu, 30 Jul 2009 00:08:57 GMT

Hi, you can use the function wildmatch(), with thw wildcards '*' for more than 1 character, or the '?' for one, this is an example script and table

t1:LOAD F1, if(wildmatch(F1,'sup*'),'True','False') as like_1, if(wildmatch(F1,'*sup'),'True','False') as like_2, if(wildmatch(F1,'*sup*'),'True','False') as like_3, if(wildmatch(F1,'?at?up'),'True','False') as like_4
INLINE [ F1 Sup sup superi Catsup Catzup];<table><tbody><tr> <th>F1 </th><th>like_1 </th><th>like_2 </th><th>like_3 </th><th>like_4</th></tr><tr> <td>Catsup </td><td>False </td><td>True </td><td>True </td><td>True</td></tr><tr> <td>Catzup </td><td>False </td><td>False </td><td>False </td><td>True</td></tr><tr> <td>Sup </td><td>True </td><td>True </td><td>True </td><td>False</td></tr><tr> <td>sup </td><td>True </td><td>True </td><td>True </td><td>False</td></tr><tr> <td>superi </td><td>True </td><td>False </td><td>True </td><td>False</td></tr></tbody></table>

I hope this can help u

Regards

Rounded Border

hector — Thu, 30 Jul 2009 00:10:12 GMT

Hi, you can use the function wildmatch(), with thw wildcards '*' for more than 1 character, or the '?' for one, this is an example script and table

t1:
LOAD
 F1,
 if(wildmatch(F1,'sup*'),'True','False') as like_1,
 if(wildmatch(F1,'*sup'),'True','False') as like_2,
 if(wildmatch(F1,'*sup*'),'True','False') as like_3,
 if(wildmatch(F1,'?at?up'),'True','False') as like_4
INLINE [
 F1
 Sup
 sup
 superi
 Catsup
 Catzup
];
<table><tbody><tr> <th>F1 </th><th>like_1 </th><th>like_2 </th><th>like_3 </th><th>like_4</th></tr><tr> <td>Catsup </td><td>False </td><td>True </td><td>True </td><td>True</td></tr><tr> <td>Catzup </td><td>False </td><td>False </td><td>False </td><td>True</td></tr><tr> <td>Sup </td><td>True </td><td>True </td><td>True </td><td>False</td></tr><tr> <td>sup </td><td>True </td><td>True </td><td>True </td><td>False</td></tr><tr> <td>superi </td><td>True </td><td>False </td><td>True </td><td>False</td></tr></tbody></table>

I hope this can help u

Regards