Looks pretty good so far.
"Add a control to the time axis allowing the user to show this information by day, week or month."
This sounds like a request for something that I typically add to charts like this - a cyclic group as the dimension. Do this:
settings -> document properties -> groups -> new -> Group Name = Period -> checkmark Cyclic Group -> add Month, Week and Day -> OK -> OK
Now in your chart, remove the Month dimension and add the Period dimension. The default view will be by month, but by clicking on the little circular arrow, you can cycle between the Month, Week and Day.
Well, the sum(CostBudgetVariance) line seems to vary plenty. So it's the sum(MoveInStatusDays) that is the problem? If so it's because it has a drastically different scale than the other. The way to display them both in a single chart is to give the second expression its own scale:
chart properties -> axes -> select sum(MoveInStatusDays) -> Position = right(Top) -> OK
Then they'll both have displayable values.
The next problem I see is that you can't see one line because the other is on top of it. I recommend using transparent colors for that.
chart properties -> colors -> click on the first color -> select "calculated" -> type argb(130,0,0,130) in the box -> OK -> click on the second color -> select calculated -> type argb(130,130,0,0) in the box -> OK -> OK
I think that makes it easier to see crossing and overlapping lines.
Ah, I see another problem. I really wouldn't define Month and Week and Day the way you have. I'd define them like this:
,date(monthstart(SnapshotDate),'MMM YYYY') as Month
,date(weekstart(SnapshotDate)) as Week
,date(SnapshotDate) as Date
The problem with what you have now is that multiple years, months and weeks will all sort of intermingle in your chart. Day 15 of every month will just show up as 15. That's probably not what you want. The code above will make sure that everything is in the right sequence and not combined on your axis.
I made all the changes you suggested and it looks a lot better - esp the
axis and the variance lines. Thanks so much! I never would have been able to
figure it out. I just realised my instructions also tell me to look at
variance for each project as of today - do you know what would mean?
On Fri, Jul 1, 2011 at 5:25 PM, John Witherspoon <
Maybe some chart that specifically just always shows today's variance? So assuming that today is one of the days in your data set, just show the variance for that day? Like this?
Dimension = project
Expression = sum(if(Date=today(),CostBudgetVariance))
Or the higher-performance alternative (look up "Set Analysis" in the help text index if you REALLY want to dive into the deep end of QlikView):
That's assuming you define the date like I mentioned, so that it's actually a date, so that it can be compared to today(). Hmmm, a particularly low performance version would be like this:
Dimension 1 = project
Dimension 2 = if(Date=today(),Date)
Expression = sum(CostBudgetVariance)
OK, seriously, I'm going home now.
Sorry to bother you, but I'm really stuck on something in QV and I just want
to run a few things by you. I'm on the last few steps of the project and I
really just want to get it done
The task wants me to show the volume for change orders by project manager
and the purchase orders by vendor. Is it possible to put this on the same
chart? Also I have to show grouping by managing office and vendor.
I don't think the expressions I have - count(changeorder_num) and
count(purchaseorder_num) does this? Plus I have to group by managing office
and vendor. So far I have made project manager a dimension and the
count(changeorder_num) and count(purchaseorder_num) my expressions. To show
grouping by managing office and vendor I used the group feature - the cyclic
one...is this correct? I've attached a screen shot of what I have so far.
I would appreciate any help as I have this task to complete as part of an
interview process and I have never used QV before. Just learning as I go!
Any help would be fantastic. Thank you!!
>> QlikCommunity <http://community.qlik.com/index.jspa>
>> Re: Trying to create a chart in QV - help! created by John Witherspoon<http://community.qlik.com/people/johnw>in
>> New to QlikView - View the full discussion<http://community.qlik.com/message/129515#129515>
It sounds to me like you want two different charts. One for the volume for change orders by managing office and project manager, and one for the purchase orders by vendor. I'm unclear how these charts would be related, so I'm guessing they aren't. I could be completely wrong, of course, but it sounds like this:
dimension 1 = managing office
dimension 2 = project manager
expression = count(distinct changeorder_num)
dimension = vendor
expression = count(distinct purchaseorder_num)
Best to probably have both charts visible at once, but if that isn't practical, you could set both charts to auto minimize when the other is opened: properties -> caption -> allow minimize -> auto minimize.
I put in "distinct" in case one change order or purchase order can appear more than once. It may not be needed in practice.
Thanks so much John. I'll try that and let you know how it goes. Much
Re: Trying to create a chart in QV - help! created by John Witherspoon<http://community.qlik.com/people/johnw>in
New to QlikView - View the full discussion<http://community.qlik.com/message/130298#130298>
I made the changes that you suggested and it looks a lot simpler and easier to read the data. Thanks. I'll have to see what they say about it. Anyways, I've also started making a Gantt Chart and I'm having some problems actually seeing the data. I looked this up and it seems that it doesn't work with the 64 bit QV - is this true?