Trouble with basic Expressions

[#1]

Hi,

I'm new to qlikview and still trying to get my head around everything, surprisingly some of probably most basic things.  Here goes..

Have a sheet where users input start and end date (could be 1 day or 6 month range).  Table 1 should shows Average sales by half Hour for the date range but entering the expression Avg(Sales) doesn't return the average of each half hour for the range, it just returns the value of 1.  What am I doing wrong?

Second question:

When the user selects a date range in the same sheet, they are also shown totals sales by Day of Week in a second table.  I need to add 2 expressions to show average sales by Day of Week for the range and also calculation of something similar to:

(DayOfWeekTotal / Average of the 7 days of the week) so the result shows a decimal, .i.e, 1.28 etc for each day of the week

Any help you could provide this newbie would be greatly appreciated.

Thank you!

[Josh_Good]

Would you be able to post the QVW.  That would help us see exactly what you are doing.

[#3]

I would love, but being new to qlikview and the community, not entirely sure how to post a qvw?

[Josh_Good]

Hit replay and then go into the advanced editor.

Once in the Advance Editor you will see "Attach" in the bottom left (next to @Mention)

I agree it is a bit hard to find at first.

[#5]

Its attached.  I'm focusing on the far right 2 charts (Workload & DOW Factors)  In the first chart, workload, the expression 'Closed Call' should be the average of 'closed calls' for the particular half hour for whatever date range is selected..

The second chart 'DOW Factors'; 'Total' Expression should be the total daily Average total calls, for each day of week, for the given date range.  The 'average' expression in the same chart should be the same as the following MS Excel formula:

A1/Average(A1:A7)  A1= 6am - Totall'.  I'm hoping i'm explaining myself well enough?

Thanks.

[Josh_Good]

I think the denominator is the issue.  If I am understanding you correctly you should be using Count(distinct date) as the denominator.

So your close call expression would be:

Sum ([is closed call]) / Count(distinct date)

The same expression would work on the DOW Total because you don't need to worry about the day of the week since the DOW factor already has the day of the week as the dimension.  Sorry I'm not following you on the DOW Average but hopefully this will point you in the right direction.

[mikecrengland]

I think another issue is that the calendar objects set variable values, but the variables aren't used in any of the expressions. Maybe change them so that they set the date field instead?

edit....

Using the date field won't work, because it needs a start and end...

[greg-anderson]

Brian, did you ever get your answer for this one?  I've been doing some more work with dates lately, and I might be able to help if you didn't find a smooth solution.

-G