Creating fake list boxes in #Qlikview (So you have much more control over appearance)

So I wanted the functionality of a list box but wanted more control over its appearance. So along comes this post by John Witherspoon

I agree that this should probably only used in limited situations but in my case I just wanted a simple selection of year and period.

Basically create straight chart with no expression

Then use the Background Color of the Dimension with a formula


To determine the color

Same with the Text Color

And text format




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s