I want to add a If else statement like this:
If ( (PMPM Amount Year ago)> (PMPM Amount), Image Arrowupward, else Imagearrowdownward). Please find the screen shot.
I am interested for Variance Field arrow. Please suggest.
You cannot insert images in Pivot tables or Tables.
But if you need to show arrow symbols, you can use expressions with Unicode characters like this:
if(rand() > 0.5,'↑','↓')
Just copy expression to your measure and replace rand() function with your expression.
More Unicode symbols you may find at https://unicode-table.com/en/
Or you may use extensions with image-representation functionality, like this https://developer.qlik.com/garden/567836fd8703093925d91d03.
Thank you so much for the input. Can you please elaborate how did you get this arrow symbol? The url provided also vast .
any of the line is fine. But I want to know the process.
thanks. Yes I do see that in Qliksense we have to use extension a lot. for example. Font size, Style etc. I am new to extension and we use Cloud . If you could elaborate this extension and how to apply it, would be great.
Two extension or custom objects are available for me and I believe the name of extension has to be attached in server Not sure. Happy to know more about it as I need it.