- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Formule QLIK SENSE --- indicateur
Bonjour à tous,
J'aimerai mettre un indicateur sur mon évolution du CA HT dans mon tableau croisé dynamique QLIK SENSE, mais impossible de le mettre en place, pouvez vous m'aider ?
Voilà mes données :
Je vous remercie.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
simply copy the indicator character
=If( YourMeasure > 0 , '▲','▼')
for text colour use the same expression
=If( YourMeasure > 0 , green(),red())
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In an expression, you could reference Column(3) and check if its value is below or above 0, then based on that result select a URL:
=If(Column(3) < 0,
'https://upload.wikimedia.org/wikipedia/commons/thumb/0/07/Button_Icon_Red.svg/300px-Button_Icon_Red.svg.png',
'https://upload.wikimedia.org/wikipedia/commons/thumb/f/ff/Green_icon.svg/512px-Green_icon.svg.png'
)
For the newly created expression, set Representation to 'Image':
|
|
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bonjour,
Merci pour la formule mais dans mon tableau croisé dynamique de Qlik Sense, je n'ai pas la fonction Image.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oui, c'est vrai. Désolée, je ne pense pas que ce soit possible dans un tableau croisé.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
simply copy the indicator character
=If( YourMeasure > 0 , '▲','▼')
for text colour use the same expression
=If( YourMeasure > 0 , green(),red())
If a post helps to resolve your issue, please accept it as a Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bonjour,
Merci pour votre réponse.