Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ankit_tikoo
Contributor II
Contributor II

Color coding based on date

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

3 Replies
lfholland
Creator
Creator

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.

ankit_tikoo
Contributor II
Contributor II
Author

Hi Laura,

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

My expression is 'JSR'

lfholland
Creator
Creator

You should be able to do something like this

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