Francophones

Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!

Who Me Too'd this solution

Not applicable

Bonjour,

Le 'S ' apparait car tu dois avoir des valeurs nulles dans ta date. Tu peux utiliser une condition pour éviter ces dates nulles :

if(len(trim([Ta Date]))>0, 'S'&num(ceil(month([Ta Date])/6))) as Semestre

Amand

View solution in original post

Who Me Too'd this solution