Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
silambarasan
Creator II
Creator II

How to give multiple color in one bar and same color in second bar in qliksense?

I want to show two measure in bar chart. 

i want to differentiate the Actual and Forecast value in one single bar chart with different color and Budget value in second bar with same color

Dataset:

one dimension and three measure

Dimension : Month-year

Measure : sum(Actual), sum(budget),sum(Forecast)

 

First six months i have to show actual value and next 6 months i have to forecast value in same bar (this i have achieved already,not in color code ), sum(Budget) is same for all 12 months.

 

Month YearActualBudgetForecast
Apr-20192.803.072.45
May-20192.743.072.45
Jun-20192.933.072.45
Jul-20192.983.072.44
Aug-20193.033.072.44
Sep-20194.433.072.44
Oct-2019 3.072.97
Nov-2019 3.072.97
Dec-2019 3.072.97
Jan-2019 3.073.18
Feb-2019 3.073.18
Mar-2019 3.073.18

 

 

Actual view :

table.PNG

 

 

Expected view in bar chart:

Basically i want to differentiate the Actual and Forecast value in one single bar chart with different color.

chart.PNG

 

 

 

2 Solutions

Accepted Solutions
silambarasan
Creator II
Creator II
Author

Can you please share the qvf

View solution in original post

4 Replies
Lisa_P
Employee
Employee

I create something like what you want.

First I created a new field, Revenue, based on Actual, or if no value, Forecast.

Then I create a Flag field called Actual which was 1, if Revenue contained Actual and 0 if it was based on Forecast.

Then to show the values you can use set analysis to create 3 measures which each have a different colour.

  • Actual   Sum({<Actual={1}>}Revenue)
  • Budget  Sum(Budget)
  • Forecast  Sum({Actual={0}}Revenue)

bar budget.PNG

 

silambarasan
Creator II
Creator II
Author

Can you please share the qvf

Lisa_P
Employee
Employee

 
silambarasan
Creator II
Creator II
Author

Thank you.