topic Re: Chart colors based on calculated dimension value in QlikView

Chart colors based on calculated dimension value

swati_rastogi27 — Wed, 29 Aug 2018 09:47:13 GMT

Hi folks ,

This is wrt a bar chart I am looking at.

I have a calculated dimension as :

=if(EOLDate = ' ', 'Current', if(DateSelected < EOLDate, 'Current', if(DateSelected < EOVSDate, 'EOL', 'EOVS')))

The expression is :

=Count(if(EOLDate = ' ', 'Current', if(DateSelected < EOLDate, 'Current', if(DateSelected < EOVSDate, 'EOL', 'EOVS'))))

In my graph , i have 3 bars , 1 for Current , 1 for EOL and 1 for EOVS

I want these colors for the bars :

'Current' -> Green

'EOL' -> Yellow

'EOVS' -> Red

Unable to do that.

Please help

shraddha_g — Wed, 29 Aug 2018 09:57:43 GMT

I would suggest to create 3 Measures in Master for Current, EOL, EOVS.

There you can directly assign colors.

Else try,

if(EOLDate = ' ', red(), if(DateSelected < EOLDate, red(), if(DateSelected < EOVSDate,green(), yellow())))

swati_rastogi27 — Wed, 29 Aug 2018 11:02:12 GMT

This expression is not working. It assigns Yellow to all the 3 bars

if(EOLDate = ' ', red(), if(DateSelected < EOLDate, red(), if(DateSelected < EOVSDate,green(), yellow())))

BalaBhaskar_Qlik — Wed, 29 Aug 2018 13:01:57 GMT

Try this, in your Background Color area of the expression:

=if(IsNull(EOLDate) OR (DateSelected < EOLDate), Green(), if(DateSelected < EOVSDate, Yellow(), Red()))

swati_rastogi27 — Wed, 29 Aug 2018 13:51:29 GMT

Unfortunately this is setting all 3 bars to green

vishsaggi — Wed, 29 Aug 2018 14:23:13 GMT

Try this?

=if(Len(Trim(EOLDate)) = 0 OR DateSelected < EOLDate, red(),

if(DateSelected < EOVSDate, green(), yellow()))