I made a pivot table with data from a SQL request:
This is the result:
And then I want to color the background of the Dimension ORT with diverse Color, but Qlik don't do it. It colo...
Hi,
I have to colour the bars of chart in colour Green (for consumption less than 850)and the rest of colour of same bar in red (for consumption more than 850).
So for "03 T...
Hi there, Want to make a look ahead condition if greater than today, red, green. Using formula:
=If(Month(Avg([EightD.D1_KPIDate])+241) > Month(Today()), RGB(0,255,0), RGB(255,0,...
Hi, Could anyone help with this colour expression? Cannot figure-out the error. Thanks a million! if(EightD.Kx_Classification='K1S' and Date(EightD.D1_KPIDate+15) > today(), R...
I have a table of in the chart section that contains calculations, the results of which range from 0 upward. Is there a way to colour the values so that the background progressively gets darker the h...
Hi everyone,
could anyone please help me getting the colour correctly.
At the moment i colour the area by expression. If value is posivite - area is green, else , area is red.
What am i d...
Hi there. I'm trying to apply conditional colouring to a pivot table but my script isn't working and I can't for the life of me work out why.
I have a measure in my pivot table of:
=S...
Hi
In KPI, I want to colour code the text and an Arrow symbol based On if condition.
If(count({<Month = {'current month'}>}ID) >=count({<Month = {'Previous month'}>}I...
Hi,
I am struggling to change button background colour when clicking the button. There are several posts here but none of them seems working....Can anyone help and check where is wrong with my s...