topic Re: Colors by expression help. in QlikView

Colors by expression help.

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

Hey everyone,

Making a simple bar chart here and trying to get my colors by expression to work. They are still all the same color. Here is my example data.

I am trying to get the table to show the percentage of employees every day based on Area_Emp.

So first I need to get Actual_Emp/FTE_Emp to get percentage, then make that either blue if below .95% or red if over .95%.

Here is the expression I am using.

Created a variable vAttend =Sum({$<Date_Emp={"$(=Date(Today()-3))"}>} (Actual_Emp / FTE_Emp))

Color expression in bar graph

if (sum(vAttend) < 0.95, '#f93f17', '#f93f17')

Currently they are all red.

Re: Colors by expression help.

sergio0592 — Mon, 03 Jul 2017 22:40:02 GMT

I'have tried and it works with color expression in bar chart:

=if($(V_attend)<0.95, Lightblue(), LightRed())

Is it that you're trying to achieve?

Re: Colors by expression help.

Anil_Babu_Samineni — Tue, 04 Jul 2017 00:06:34 GMT

Hello,

Hext decimal codes won't work with in the qlikview. You must use the default functions or RGB colors

Re: Colors by expression help.

joshrussin — Wed, 05 Jul 2017 14:39:02 GMT

It is what I am trying to achieve but still isn't working.

Re: Colors by expression help.

joshrussin — Wed, 05 Jul 2017 14:39:55 GMT

Oh, gotcha. I tried the lightblue() and lightred() as instructed above and still could not receive any color. Thanks!

Re: Colors by expression help.

vishsaggi — Wed, 05 Jul 2017 14:51:07 GMT

Can you share that sample file your are trying this?

Re: Colors by expression help.

joshrussin — Wed, 05 Jul 2017 15:05:26 GMT

Data:

Dimension: Area_Emp

Measures: =Sum({$<Date_Emp={"$(=Date(Today()-2))"}>} (Actual_Emp / FTE_Emp))

I am subtracting two to show the 3rd because that is the latest work day for this demo.

variable added via "variables" tab

vAttend =Sum({$<Date_Emp={"$(=Date(Today()-2))"}>} (Actual_Emp / FTE_Emp))

Appearance:

Expression: =if ((vAttend) > 0.95, red(), blue())

Re: Colors by expression help.

vishsaggi — Wed, 05 Jul 2017 15:10:35 GMT

Try like this?

Expression: =if ($(=vAttend) > 0.95, red(), blue())

If not you have share the sample data as a table it takes time to create a table typing all the relevant field values. Paste your data as a table or upload your sample qvw file please to quickly look into it.

Re: Colors by expression help.

joshrussin — Wed, 05 Jul 2017 15:15:35 GMT

That did not work either. Here is the file. the chart is in the "daily summary" sheet

Re: Colors by expression help.

vishsaggi — Wed, 05 Jul 2017 15:23:41 GMT

Is this a Qliksense app?

Re: Colors by expression help.

joshrussin — Wed, 05 Jul 2017 15:24:28 GMT

yes

Re: Colors by expression help.

joshrussin — Wed, 05 Jul 2017 16:43:17 GMT

Could you attach the sample file for this to see what I could be doing wrong, please? Thanks!

Re: Colors by expression help.

joshrussin — Wed, 05 Jul 2017 16:43:40 GMT

Any luck?

Re: Colors by expression help.

vishsaggi — Wed, 05 Jul 2017 17:35:33 GMT

Hey so sorry was stuck with work. Will check in a while.

Re: Colors by expression help.

sunny_talwar — Wed, 05 Jul 2017 17:39:52 GMT

Remove the equal sign from your variable

Re: Colors by expression help.

BalaBhaskar_Qlik — Wed, 05 Jul 2017 18:14:01 GMT

Try this:

Expression: =if ('$(vAttend)' > 0.95, red(), blue())

Re: Colors by expression help.

vishsaggi — Wed, 05 Jul 2017 18:33:14 GMT

Strange, why i am unable to open this file in Qlik Sense? Sunny any help on how you open this file?

Re: Colors by expression help.

joshrussin — Wed, 05 Jul 2017 18:33:49 GMT

I see it working. I've made all the changes I need to but still only shows red in my app.

Re: Colors by expression help.

sunny_talwar — Wed, 05 Jul 2017 18:38:02 GMT

I have no idea....

Re: Colors by expression help.

sunny_talwar — Wed, 05 Jul 2017 18:38:15 GMT

Seeing red in the attached app also?