Advertisements

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

http://community.qlikview.com/message/119349#119349

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

=if(len(Employee),rgb(80,80,80),black())

To determine the color

Same with the Text Color

And text format

=if(len(Employee),'<b>’)

 

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: