topic Re: how to write a script for last 30 days value(variable) in QlikView

how to write a script for last 30 days value(variable)

jim_chan — Tue, 02 Aug 2016 09:50:39 GMT

Hi guys,

I have created a variable. wanted to use it with the belwo last 30 days expression. i coudlnt get any value, iwhat is wrong with the expression??

=Sum( If( AddMonths(Today(),-1) ,$(vAmount1)))

Rgds

Jim

sunny_talwar — Tue, 02 Aug 2016 09:51:55 GMT

Can you show how you define vAmount1 variable?

kaushiknsolanki — Tue, 02 Aug 2016 09:53:08 GMT

Hi Jim,

So you mean you want them amount from last 30 days.

Then you should use.

Sum({<Date = {">=$(=Addmonths(Max(Date),-1))"}>}Amount)

If not then please give some example to understand your issue.

Regards,

Kaushik Solanki

jim_chan — Tue, 02 Aug 2016 09:57:01 GMT

is very long expression in it.

Sum (If (A_Funds = 'FUNDS_IN', local_amt))

+ Sum(If (B_Funds = 'FUNDS_IN', cust_local_amt))

+ Sum(If (C_funds = 'FUNDS_IN', payout))

(Sum (If (A_Funds = 'FUNDS_OUT', local_amt))

+ Sum (If (B_funds = 'FUNDS_OUT', ttl_payout))

+ Sum (If (C = 'FUNDS_OUT' and claim_com_code <> 'CHY', claim_local_amt)))

- sum(session_actual_winner)

sunny_talwar — Tue, 02 Aug 2016 09:58:52 GMT

So I guess you are trying to do aggregation within aggregation which would require you to use Aggr() function.

jim_chan — Tue, 02 Aug 2016 10:00:45 GMT

is too long to add in that expression into this:

Sum({<Date = {">=$(=Addmonths(Max(Date),-1))"}>}Amount)

sunny_talwar — Tue, 02 Aug 2016 10:02:18 GMT

Would you be able to share a sample?