Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a KPI figure for revenue and I want to add another measure for last month revenue. How would I accomplish this? How might I change the color of this month revenue and glyphs when this month revenue > last month or < last month?
Thank you so much.
Under Measures > Your expression > 'on' conditional colors > click on the Add limit value. you will get colors and symbols. Select the symbol you want.
Hi Santosh, I am trying to create exactly what you're illustrated above but I'm not getting anywhere! (I'm very new to Qlik and have been enjoying the out of the box visualisations but dont really have any experience of using expressions or even really where you put them!) I've attached a .qvf in the hope you or any other willing volunteer might have time to throw those expressions in the right places and make it sing so I can see a working demo and backwards engineer it from there! Any help much appreciated, fingers crossed
Hi
Is this you are looking for?
Santhosh
Hi Santhosh, I can't see an attachment, but maybe I'm being blind
here is the attachment
Thanks Santhosh but I don't think that's quite what I was looking for, I'm trying to create your example above that looks like this:
, I'm trying to create your example above that looks like this:
Do you mean the % sign?
Hi
if you are are looking for color and symbol change, you can do so by selecting a name from the list and if you are looking for variance%, that you need to take difference of two different values in place of existing expressions.
Santhosh
No the whole thing i.e three KPIs, one reflecting the month selection, one reflecting the previous month to the month selection, and one displaying the variance.