Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to use 2 colors to differentiate on a chart when change the value of a dimension compared to the previous value. Is it possible to leave it as shown in the picture?
Usually i do these things using a macro in Excel but this time i need it in Qlikview.
Thanks!
This one seems to be trickier than it should be...never the less I have a possible solution:
The only soloution I could come up with I'm affraid is more script based and isn't 100% robust but may well be of use - look at the script and the Dimension BackGround colour and I'm sure you'll be able to decode it.
File attached.
Hope that helps,
Matt - Visual Analytics Ltd
Hello,
You could try this expression for the background of your Dimension Terminal -> if (Name = aaa,YELLOW(), BLUE()).
You need to modify the above expression a bit, but its around this...please try
Mama
This one seems to be trickier than it should be...never the less I have a possible solution:
The only soloution I could come up with I'm affraid is more script based and isn't 100% robust but may well be of use - look at the script and the Dimension BackGround colour and I'm sure you'll be able to decode it.
File attached.
Hope that helps,
Matt - Visual Analytics Ltd
Excelent Matt, i was wondering if would be necesary something similar using autogenerate, but your solution is perfect and very useful.
Thanks!!