You guys helped me a couple weeks ago. I have been working with Qlikview for a couple years, but the Pick function is one I haven't completely wrapped my head around. I have been told it performs better than an If statement, and it should always be used instead of IF.
I have attached a document. I am using a straight table chart as navigation and wish to format the currently selected value. Pretty basic if statement would get me what I am looking for.
This is a dumbed down version of what I am doing, so you don't have to worry about forcing the user to select one value. I am just looking to replace this If statement in the Background Color.