Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
shumailh
Creator III
Creator III

Rounded Border

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

3 Replies
hector
Specialist
Specialist

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

hector
Specialist
Specialist

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

hector
Specialist
Specialist

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