article How to - Dynamic Look and Feel in Member Articles

How to - Dynamic Look and Feel

robert_mika — Tue, 20 Sep 2022 17:59:53 GMT

How to - Dynamic Look and Feel

The concept here is to have colors and logo dynamically changed based on a listbox.

Steps:

Download attached package and saved included picture to a folder.

Create new application and copy and paste below code:

Company:

load * inline [

PickName,Company,val

pepsilogo.jpg,Pepsi,1

cokelogo.jpg,Coke,2

catlogo.jpg,Cat,3

]

;

Colors:

load * inline [

No., Pepsi, Coke,Cat,Variable Name,Info

1, 'RGB(232,17,45)','RGB(184,19,33)','RGB(0,0,0)',vTabActiveBg,Active Backround

2, 'RGB(0, 133, 202)','RGB(51,11,12)','RGB(255,223,0)',vTabInactiveBg,Incative Background

]

;

T1:

load * inline [

Product,Value,Country

A,1,Russia

B,2,UK

C,3,Poland

D,4,Germany

E,5,Czech

]

;

pics:

bundle load * Inline

[

PickName,Path

pepsilogo.jpg,'D:\Multilanguages\pepsilogo.jpg'

cokelogo.jpg,'D:\Multilanguages\cokelogo.jpg'

catlogo.jpg,'D:\Multilanguages\catlogo.jpg'

]

Change this part

'D:\Multilanguages\catlogo.jpg'

to a path with a folder with your pictures.

Reload.

Create:

a) List box - with field "Company"

b) Bar chart -- with "Product" as Dimension

and SUM(Values) as Expression

c) Text box-

with Representation as "Image"

and below expression in Text box:

=if(Company=Company,Info(PickName),'NA')

Add 3 variables:

a) vTabActiveBg

=$(=fieldvalue($(vCompany),1))

b) vTabInativeBg

=$(=fieldvalue($(vCompany),2))

c) vCompany

=Chr(39)&Company&Chr(39)

In the Caption section of an object change the Base Color of " Active " and "Inactive Colors" to

"Calculated" with an expression

for "Inactive Caption" use:

=vTabInactiveBg

For "Active Caption"

=vTabActiveBg

The final picture will be similar to this one

Now you can use the list box to change the colors and the logo of the company.

As you probably realize at this point, you can add more variables to have every other color dynamically change this way.

Feeling Qlikngry?

How To /Missing Manual(23 articles)

Re: How to - Dynamic Look and Feel

vikasmahajan — Wed, 02 Dec 2015 04:32:43 GMT

Thanks for Sharing

Re: How to - Dynamic Look and Feel

gautik92 — Wed, 02 Dec 2015 04:45:50 GMT

Good one Thanks for sharing

Re: How to - Dynamic Look and Feel

manojkulkarni — Wed, 02 Dec 2015 06:17:18 GMT

good one

Re: How to - Dynamic Look and Feel

fmazzarelli — Thu, 07 Jan 2016 21:31:10 GMT

Hi,

I tried to replicate what you did but I have difficulty in using Qlik sense when you write

c) Text box-

with Representation as "Image"

and below expression in Text box:

=if(Company=Company,Info(PickName),'NA')

and

In the Caption section of an object change the Base Color of " Active " and "Inactive Colors" to

"Calculated" with an expression

for "Inactive Caption" use:

=vTabInactiveBg

For "Active Caption"

=vTabActiveBg

My result is ... the image attached

Re: How to - Dynamic Look and Feel

robert_mika — Thu, 07 Jan 2016 22:27:43 GMT

Could you attached your app?

Re: How to - Dynamic Look and Feel

fmazzarelli — Fri, 08 Jan 2016 11:40:24 GMT

I am ashamed but I do not know how to do

Re: How to - Dynamic Look and Feel

Anonymous — Thu, 14 Jan 2016 08:58:14 GMT

Thanks for sharing, I've never used the function Info() like this. I have to say an open mind is indispensable when we work with Qlik.