topic Re: Display Color Button in QlikView

Display Color Button

tracycrown — Wed, 25 Nov 2020 16:16:04 GMT

Dear all

I found an interesting page in www.360globalconsulting.com under Products-Project and was told that they designed using Qlikview BI Tool.

Can someone advise me how to display colour button shown in attached file ?.

Thank you

Tracy

maxgro — Wed, 14 Sep 2016 17:16:38 GMT

I think with

representation image in chart expression

then in edit expression go to Images tab and choose the image

Anil_Babu_Samineni — Wed, 14 Sep 2016 17:16:55 GMT

Are you asking about Tabs?

tracycrown — Sun, 18 Sep 2016 14:28:09 GMT

Dear Massimo

Not bar, it is a colourful button / dot.

Thanks

Tracy

maxgro — Sun, 18 Sep 2016 15:33:39 GMT

last column in my image is a dot

you can choose the color of the dot adding an if (image), i.e.

if(odd(RowNo(TOTAL)),

'qmem://<bundled>/BuiltIn/led_o.png',

'qmem://<bundled>/BuiltIn/led_g.png'

)

replace the bold with your condition

if(sum(....) > ...., 'qmem://<bundled>/BuiltIn/led_o.png',

if(sum(....) > ...., 'qmem://<bundled>/BuiltIn/led_g.png',

if(sum(....) > ...., 'qmem://<bundled>/BuiltIn/led_r.png',

.....

)))

tracycrown — Thu, 22 Sep 2016 15:03:16 GMT

Dear Massimo

Not sure how to do it. Can your script display the same answer as the image below ?.

Thanks, Tracy