Qlikview variable

[Anonymous]

Guys,

I have an expression stored in a variable as below,

vBillingStatus = Aggr(Sum(MonthlyBillableWorkHour)/Count(Distinct EmployeeID),EmployeeID)

But I'm using this expression in a bar chart having three bars for the following values,

1. vBillingStatus >7, Occupied

2. vBillingStatus <4, Available

3. vBillingStatus <8 and >3, Partially Occupied

I couldn't set static colors for each of the bars in the bar chart since the value is stored in a variable. So, please help me how to solve this.

[Anil_Babu_Samineni]

Colors you want to apply

If(vBillingStatus < 4, Yellow(), If(vBillingStatus > 3 and vBillingStatus <8, Red(), If(vBillingStatus > 7, Green())))

Or

If($(vBillingStatus) < 4, Yellow(), If($(vBillingStatus) > 3 and $(vBillingStatus) <8, Red(), If($(vBillingStatus) > 7, Green())))

[yoganantha321]

Anil it is not working

[vishsaggi]

Can you share a sample to look into? And does your variable display any values?

[Anil_Babu_Samineni]

How variable values are returning on your case? Would you post sample qvw which demonstrates the output

[avinashelite]

Do you have the EmployeeID in your chart as the diemsion ? if not then it won't work because your aggr on the EmployeeID ..so change the aggr based on the dimension in the chart then it will work

Hope this helps you