But i dont understand why my app is showing only Idle bar , i copied the same thing , i am attaching my app here , you cannot work on it but atleast you can see the properties i guess.
I have the column UTIL_RATE in my table not AVG(UTIL_RATE) , So i changed the calculated dimension to (removed the double quotes) , but still only idle is showing ..:-(
RAMYA_BEGINNER wrote:what could be the possible reason for not displaying used and idle bars separetely?
It looks like you figured out that you need to replace "AVG(UTIL_RATE)" with "UTIL_RATE" since that's what the column is called in your actual data set. However, since you've also added the Calendar dimension, you need to aggr by that as well.
You can't tell that you need this in the sample data set because you have the same exact UTIL_RATE for every day. But you can see it if you, say, change the Calendar dimension to SITE_NAME. Then you can see, for example, that for Santa Clara, 8960_APPS is shown as Used even though sum(UTIL_RATE) is only 1. I assume you'd want this to show as Idle.
I hope you don't mind, but I'm going to post your private message to me here since I see no reason this shouldn't also be part of this thread:
RAMYA_BEGINNER wrote:Hi This is in continuation for the post http://community.qlik.com/forums/t/39662.aspx thank you for the response for my question , i have an addition to my application , i need to add another line chart which shows , count of rumi devices in 3 lines , line for idle line for used line for all i am able to get lines in the chart with calculated dimension condition for idle and used =aggr(if(sum(UTIL_RATE)>2,'Used','Idle'),TARGET) i need to combine another condition given below , to get a line displaying all count of all devices =aggr(DISTINCT SUM(RUMI_DEVICE),TARGET) How do i combine both of these expression into one , if combining is not an option , how can i achive 3 lines in my line chart displaying used,idle,all Please let me know... Thanks...
I'd just use three separate expressions, and I'm assuming below that your dimension is again Calendar.
Total = count(distinct RUMI_DEVICE) Used = sum(aggr(if(sum(UTIL_RATE)>2,count(distinct RUMI_DEVICE)),Calendar,TARGET)) Idle = Total - Used
That seemed to work for me with your file, though I had te replace Calendar with SITE_NAME in order to verify. And if Calendar isn't your dimension, replace it in the expression above with whatever your dimension actually is.
To explain what's going on in the "Used" expression, the aggr(...,Calendar,TARGET) groups your data by calendar and target. So if you have Date selected in your Calendar, for each date and target, we sum(UTIL_RATE). If that sum is > 2, then that TARGET is Used for that Date. Therefore we must count the distinct RUMI_DEVICE for that Target. Finally, since TARGET isn't actually a dimension in our chart, we must sum up these counts for all Used TARGETS on that date to get our total Used RUMI_DEVICEs. Hopefully the other two expressions are obvious.
