Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hallo everyone,
i'd like to know, if there's any way in QlikSense to change the textcolor of a measure (depending on it's value), by JUST NAMING it.
If([SaleCurrentYear (Vergleich Grosskunden)] < 0, red(), black())
itself doesn't work (says: 'wrong fieldname') - if i copy paste the full definition-formula of the measure into it instead, it works, but each of these definitions are several hundred lines of code long and it simply takes much more time to look up the definition everytime using it. Also hardcopying such measure-definitions make tiny future changes a pain...
Is there a trick, how i can just name it?
Hi
you can't change the text color of a mesure by naming it or use the name of the master mesure you hac created.
Nethertheless you can achieve your requierment by using variable
create a variable and name it for exemple
vMesure1 = sum(sales)
then as color mesure use :
if($(vMesure1) < 0, red(), black())
hope it helps
where are the definitions located? In variables? In some table? WHere did you copy-paste from?
Hi
you can't change the text color of a mesure by naming it or use the name of the master mesure you hac created.
Nethertheless you can achieve your requierment by using variable
create a variable and name it for exemple
vMesure1 = sum(sales)
then as color mesure use :
if($(vMesure1) < 0, red(), black())
hope it helps
Thanks @brunobertels - this will surely does the trick...
I thought about this earlier, too - but it seems odd, that i can't just use a measure/'master-measure' instead.
Often i really can't imagine, why QlikSense restrictions are, as they are (and remain like that)...
@gmenoutis :
I have defined measures like this one each as master element (not created via script)