topic Re: Set analysis for amount in QlikView

Set analysis for amount

Thu, 29 May 2014 00:05:26 GMT

Hi guys,

I need to calculate the Amount for the customers with minimum transactions date.

Here is the expression...

sum({1<Date={$(=Min({1<Type={'Invoice'}>}Date))}>}Amount)

But it is not working..

any idea guys?

Saurabh

Re: Set analysis for amount

eduardo_sommer — Thu, 29 May 2014 00:17:20 GMT

If Iunderstood your expression it will sum all the 'invoices' with date exactly the same as the minimum date in all data. If your date also contains the time, it will also be compared with litle probability of match. I think this is not what you wanted to get.

Please send more details and, if possibl, share the application

Eduardo

Re: Set analysis for amount

Thu, 29 May 2014 00:39:19 GMT

You understood it correctly ....

my date do not contain time though...

Sharing application is difficult...I will try

It seems to be a simple expression....I am not sure what is wrong here..

Re: Set analysis for amount

eduardo_sommer — Thu, 29 May 2014 02:02:14 GMT

if the result you want is the sum of the first invoices of all customers,you can use the following expression.:

sum(aggr(firstsortedvalue(Amount, Date),Customer)
This expression will pick the first invoice of each customer and sum their amounts.

Is this what you were looking for?

Eduardo