topic Lost Amount (Set Analysis) in QlikView

Lost Amount (Set Analysis)

mario-sarkis — Thu, 23 Jul 2015 06:53:29 GMT

Hey ALL,

here is my question i need to create a line chart that shows me the lost amount monthly which is caculated this way:

(sum({<[Party]={1},[Product/GL]={'Product'}, [RM Finance PeriodDate]={$(=max([PeriodDate]))}>}[Balance USD]) -

sum({<[Party]={1},[Product/GL]={'Product'},[PeriodDate]={$(=num(DayStart(monthend(YearEnd(AddMonths(max([PeriodDate]),-1))))))}>} [Balance USD]))/1000000

The problem is that it shows me only for one month. my requirement is to show the evolution occurs,

Please help anything wrong in my expresssion ?

Re: Lost Amount (Set Analysis)

qumniusomnius — Thu, 23 Jul 2015 07:05:19 GMT

try with adding <= in the date set analysis :

(sum({<[Party]={1},[Product/GL]={'Product'}, [RM Finance PeriodDate]={<=$(=max([PeriodDate]))}>}[Balance USD])

sum({<[Party]={1},[Product/GL]={'Product'},[PeriodDate]={<= $(=num(DayStart(monthend(YearEnd(AddMonths(max([PeriodDate]),-1))))))}>} [Balance USD]))/1000000

hope it helps

Re: Lost Amount (Set Analysis)

mario-sarkis — Thu, 23 Jul 2015 07:12:32 GMT

hi borja,

Thank you for you reply but it shows me:

"Allocated memory exceeded"

any other Idea ?

Re: Lost Amount (Set Analysis)

sasiparupudi1 — Thu, 23 Jul 2015 08:49:11 GMT

Please post your application