topic Re: Color coding based on date in QlikView

Color coding based on date

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

Hi All.

I have created a chart table for a dataset. In the dataset I have a date field. I have connected that date field to master calender.

When I change the date, values of expression in chart table change accordingly as per the situation at the selected time.

The data actually has the date of activation for all features for a product on various clients/companies

I want to color code those features which have been activated in the last 3 days with red color.

Sample table that I have prepared is below:

Feature 1 Feature 2 Feature 3 Feature 4

Google 1 1 0 0

Amazon 0 0 0 1

Flipkart 0 1 1 1

FedEx 1 0 0 0

1 stands for active 0 stands for not active. A feature may not be active in 2011 but maybe active in 2018. Change in date shows this info accordingly.

I want to color code those clients where the value has become 1 for a feature in last two days. Need some formula

Can you suggest a solution

Re: Color coding based on date

lfholland — Mon, 13 Aug 2018 14:09:50 GMT

You might be able to do something like this:

=if(InvoiceDate>=today()-5,rgb(124,252,0),rgb(128,0,0))

You can do the same formatting on dimensions. You can do an "AND" to add the criteria for the value being a 1. I had to use today()-5 because today is Monday and the last date in our system was Friday, that way I go some stuff to change color. For the rgb colors, you can just google rgb values for different colors and choose whatever value you like. Hope this helps.

Re: Color coding based on date

ankit_tikoo — Tue, 14 Aug 2018 07:29:57 GMT

Hi Laura,

Thanks... This helped. However I am still not sure how to include that value='1' condition.

My expression is 'JSR'

Re: Color coding based on date

lfholland — Tue, 14 Aug 2018 17:19:33 GMT

You should be able to do something like this

=if(Date>=today()-2 AND YourField = 1,rgb(124,252,0),rgb(128,0,0))