topic Re: Sense Background color in QlikView

Sense Background color

Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

I have very small requirement in qlik sense i.e is

i have one dimension and 2 measures in bar chart

dim : product

measure : 1)investamount

2) achvamount

now my req is i want write color expression for each measure separately.

i meant to say ,..

in chart : dim : product

measure : sum(investamount) , if(sum(invest amount) <500 ,red(),blue()) (color expression)

measure2 : sum(achvamount) , if(sum(achvamount) <300,yellow(),gray()) (color expression)

how to achiev this in sense ?

Re: Sense Background color

Mon, 17 Apr 2017 06:31:05 GMT

33 views ? But no reply .

is it possible in qlik sense ?

Re: Sense Background color

rahulpawarb — Mon, 17 Apr 2017 07:18:36 GMT

Hello Manoj,

Not sure how to handle this; but I hope below given link will be of help.

Mapt - Developer skills delivered

Regards!

Rahul

Re: Sense Background color

Anonymous — Mon, 17 Apr 2017 07:20:08 GMT

May be using these??

Re: Sense Background color

Anil_Babu_Samineni — Mon, 17 Apr 2017 07:30:11 GMT

I don't think whether we have access for Qliksense. in qlikview, we have straight forward. Let me play around if it so i will come back to you.

Re: Sense Background color

Mon, 17 Apr 2017 07:37:16 GMT

Hi Anil,

As u said we have in qlikview very straight forward to do this .

But Sense is giving trouble

Re: Sense Background color

Mon, 17 Apr 2017 07:38:45 GMT

Hi Shiva,

Yes I tried with this ,

my intention is to write different background color expression for each expression ,

but it is allowing us to write one expression and it is getting applied for 2 expressions

Re: Sense Background color

Anil_Babu_Samineni — Mon, 17 Apr 2017 07:39:26 GMT

True, If you want response from Qliksense team. You may move this thread New to Qliksense instead of New to Qlikview

Re: Sense Background color

Mon, 17 Apr 2017 07:44:45 GMT

Ya sure , I will do that

Re: Sense Background color

Anil_Babu_Samineni — Mon, 17 Apr 2017 07:53:54 GMT

Have a look here

Re: Sense Background color

Anonymous — Mon, 17 Apr 2017 07:54:40 GMT

Manoj, Have you tried this?? Qlik Sense: How to set custom colors by measure in a bar chart

Re: Sense Background color

Mon, 17 Apr 2017 08:33:10 GMT

Hi Shiva,

I got the result with above reference file.

but now the issue with second dimension legends

Thanks a lot for sharing this

Re: Sense Background color

Mon, 17 Apr 2017 08:55:48 GMT

Achieved it through ur thread ,

Thanks A lot

used to avoid legends of second dimension like this

valuelist(' '),' ')

Re: Sense Background color

vb00494773 — Mon, 17 Apr 2017 09:22:26 GMT

Hi Anil,

thanks for the work done, can you please let me know the same process for Combo chart. However we have limitation like only one dimension can be added .

Thanks,

Venkatesh