topic Re: Sum 3 variables. How do I do it? in QlikView

Sum 3 variables. How do I do it?

knightwriter — Tue, 14 Jul 2015 13:26:22 GMT

Hi gurus,

I have a query regarding an expression I am trying to use and I am hoping you can help me.

So I want to get:

1) The average of a total fees

2) In 2015

3) and status = Won

I have the below but I cannot get it to work. Any guidance is appreciated.

=Avg(Distinct If(InYear([opportunity.fee] and [Opportunity.Won Date], Today(), 0) and [Opportunity.Sales Stage]=vWon,[Id],))

Many thanks.

sunny_talwar — Tue, 14 Jul 2015 13:34:11 GMT

May be this:

=Avg({<Year = {'2015'}, Status = {'Won'}>}[Total fees])

knightwriter — Tue, 14 Jul 2015 13:51:24 GMT

Hi Sunindia,

Thanks for the note but I still cannot manage to work it. The message is Error in expression. Any other suggestions?

sunny_talwar — Tue, 14 Jul 2015 14:35:42 GMT

Can you post a screenshot of when you enter the above expression in edit expression window?

jonathandienst — Tue, 14 Jul 2015 14:46:34 GMT

I am afraid the expression you posted does not make sense. This bit will likely give you an expression error (and will not work):

InYear([opportunity.fee] and [Opportunity.Won Date], Today(), 0)

(the bold text returns a true/false value and not a date which InYear is expecting

Plus you have a trailing comma which will cause an error

=vWon,[Id],))

jonathandienst — Tue, 14 Jul 2015 14:49:07 GMT

And please give the definition of vWon