Tag: Qlikview Script

chr(10)

In the button properties, you could create an action that will toggle variable (I will call this variable vToggle): Actions -> Add-> Action Type: External...

PurgeChar(text, remove_chars) ou KeepChar(text, keep_chars) Argument Description text Chaîne d'origine. remove_chars Chaîne contenant les caractères figurant dans text à supprimer.   Argument Description text Chaîne d'origine. keep_chars Chaîne contenant les caractères figurant dans text à conserver.   Exemple Résultat PurgeChar ( 'a1b2c3','123' ) Renvoie 'abc'. PurgeChar (...

SubField(text, delimiter) Argument Description text Chaîne d'origine. Il peut s'agir d'un texte codé de manière irréversible, d'une variable, d'une expansion dollar ou d'une autre expression. delimiter Caractère inclus dans la...

https://community.qlik.com/t5/Qlik-Design-Blog/Loading-Data-into-Input-Boxes/ba-p/1469453?collapse_discussion=true&filter=location&location=category:qlik-community-blogs&page=7&q=qvw&search_type=thread

Data Cleansing When building business intelligence solutions one problem is that data usually contains errors, e.g. attributes are written in different ways so that data...

Some time ago I wrote a blog on Mapping functions and described how they can be used to replace or modify field values when you run...

On utilise la fonction ValueList() If not, let me introduce you to ValueList() and its number oriented big brother ValueLoop(). ValueList (value {, value }) Calcul de...

TextBetween(text, delimiter1, delimiter2) Le résultat :    

Formule :  networkdays (start:date, end_date {, holiday}) Variable :  SET vHolidays = "'20-Jan-2015','03-01-2015','09-01-2015'"; Expression du rapport :  =NetWorkdays('01-01-2015','20-01-2015',$(vHolidays))