Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Qlik sense; color by dimension in combination with point in time reporting

Hi all,

I made a simple example data set;

VendorSpendContractDate fromDate to 


Based on this data set a want to make a bar chart. 

As the dimension I take the vendor and as meassure i take the sum of spend. 

I made a button to report actual data and a button to pick a date in the past. 

So actual the spend for vendor A = 100 without contract but on, for example, the 15th of januari the spend for vendor is 100 with contract. 

I color the bars by the dimension 'contract'. 

The bar for vendor A is always grey. No matter what date i select.

I want the bar to be yellow in january (contract = J) and red in, for example march (contract =N).

How do i fix this? Please see the attached qvf file. 

Thanks in advance. 

Kind Regards, 



2 Replies

I have managed to do this in my app, but your app has date limitations, so does not show all the data.


I first created a Master dimension for Contract and customized the colors to be yellow and red for J and N

Then I added Contract as a second dimension in the chart, made it stacked and colored by the Master dimension Contract.

Contributor II
Contributor II

Hi Lisa_P,

Thanks for your reply. In your solution it looks like the spend for vendor A is 200. 

This is not correct. The spend for vendor A is 100. Its just that there is a contract until 31-01-2020 and no contract after that date. 

So depending no matter what date i select in my app, the spend for vendor A must Always be 100. 

De color of vendor A should switch depending on the date selected in my app.