topic Re: Help with total function in QlikView

Help with total function

Tue, 24 Sep 2013 11:38:04 GMT

I have created a chart which basically has the following values

Date	Customer	Time	% Time Spent
26/08/2013	Epicor	6:30	%100
27/08/2013	Epicor	4:00	%53
27/08/2013	RB	3:30	%47
28/09/2013	Dixon	1:00	%11
28/09/2013	Epicor	2:00	%22
28/09/2013	RB	5:30	%67

The expression for the total time is:

sum(EndDateTime - StartDateTime) / sum(TOTAL <Date> EndDateTime - StartDateTime)

Which works fine when nothing is selected.

As soon as I select a customer, the percentages changes to be %100. I assume this is because the expression is going off what is I selected.

How can I change the expression, so the TOTAL figures is the total time spent on each day, irrespective of what has been selected.

Thanks

Andy

I have added the dashboard and the excel file

Anonymous — Tue, 24 Sep 2013 15:04:45 GMT

Hi Andy,

Would you care to attach your QVW file?

Cheers,

Antoine

whiteline — Tue, 24 Sep 2013 19:33:41 GMT

Hi.

With set analysis you can modify user selections that is used for expression.

For example to discard customer selection:

sum({<Customer=>}TOTAL <Date> EndDateTime - StartDateTime)

israrkhan — Tue, 24 Sep 2013 20:01:09 GMT

hi Fearn:

try Below Expression, May This Help:

=sum({1<EndDateTime - StartDateTime>}) / sum({1<TOTAL <Date> EndDateTime - StartDateTime>})

Khan

Wed, 25 Sep 2013 10:39:06 GMT

Thank you for helping but your expression I couldn't get your expression to work

Wed, 25 Sep 2013 10:39:58 GMT

That worked.

Thanks

Andy

MK_QSL — Wed, 25 Sep 2013 12:52:45 GMT

=sum({1}EndDateTime-StartDateTime)/sum({1}TOTAL <Date> EndDateTime-StartDateTime)