topic Re: Qlikview variable in QlikView

Qlikview variable

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

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.

Re: Qlikview variable

Anil_Babu_Samineni — Thu, 20 Apr 2017 15:41:51 GMT

Colors you want to apply

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

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

Re: Qlikview variable

yoganantha321 — Thu, 20 Apr 2017 16:53:00 GMT

Anil it is not working

Re: Qlikview variable

vishsaggi — Thu, 20 Apr 2017 18:34:38 GMT

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

Re: Qlikview variable

Anil_Babu_Samineni — Fri, 21 Apr 2017 05:28:43 GMT

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

Re: Qlikview variable

avinashelite — Fri, 21 Apr 2017 05:32:52 GMT

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