Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to make a clear view of the client activity. I've done the following thing
Here you can see the activity per week per client for the current year.
To make it more clear i would like to make the week where was no activity for the client red (instead of empty). I've tried the following adjustments but it didn't worked out yet.
if(
sum({$<jaar = {"$(=Year(Today()))"}>} LEVTOTAAL)>0,
If(
sum({$<jaar = {"$(=Year(Today()))"}>} LEVTOTAAL)>0,
1,
-1)
)
Anyone who tried to do something similar and can help me out?
Hi Rob, in this situation maybe you can do a trick to color the minichart bars:
Set an expression that returns '1' for the blue green bars and '1-0.001' (a little less than '1') for the red bars.
In the minichart configuration you can set a color for the max values ('1') and a color for the min values ('1-0.001')
Hi Ruben,
A you can see in the expression I tried to give the sum of LEVTOTAAL value 1 when positive, otherwise a -1.
if(
sum({$<jaar = {"$(=Year(Today()))"}>} LEVTOTAAL)>0,
If(
sum({$<jaar = {"$(=Year(Today()))"}>} LEVTOTAAL)>0,
1,
-1)
)
Hi Rob, my trick is to show all bars almost equal in heigth, so instead of a '-1' you need to set a value wich is almost '1' like '1-1/100'. Visually it will look as equal bars but qlikview can identify wich bars are higher and set the colors according to the max and min values.
BTW, the expression maybe should be:
if(
sum({$<jaar = {"$(=Year(Today()))"}>} LEVTOTAAL)>0, 1, 1-1/100) //change '100' to '1000' or '10e6' if bars don't look equal
)