topic Re: Refrencing a column calculation in QlikView

Refrencing a column calculation

Mon, 09 Mar 2015 07:25:07 GMT

Dear all

I am facing a problem i have an expression which are given below having label 'Last date'

max({<Flag={'Disbursal'}>}Date)

when ever i reference the column in other expression which are given below

=Sum({<Flag={'Disbursal'},Date={'[Last date]'}>}AMOUNT

)

it give me 0 rather than given me the amount of that date

amit_saini — Mon, 09 Mar 2015 07:31:46 GMT

Asif,

Try this:

=Sum({<Flag={"Disbursal"},Date={"[Last date]'"}>}AMOUNT)

Thanks,

Mon, 09 Mar 2015 08:01:17 GMT

it cant works return 0

when i reference the column [Last date] it gives number rather than date

martinpohl — Mon, 09 Mar 2015 08:06:43 GMT

It doesn't work with set analysis only, you have to mix it with the max date for each dimension (in that case by customer.

sum( if( aggr(nodistinct max({<Flag={'Disbursal'}>}Date), Customer) = Date, Amount, 0))

Regards

chrislofthouse — Mon, 09 Mar 2015 08:23:41 GMT

Try this:

Sum({<Flag={'Disbursal'},Date={"$(=max({<Flag={'Disbursal'}>}Date) )"}>}AMOUNT)

Mon, 09 Mar 2015 09:26:55 GMT

Thanks it works

jagan — Mon, 09 Mar 2015 09:28:53 GMT

Hi,

Try this expression

=Sum({<Flag={'Disbursal'},Date={'$(=Date(max({<Flag={"Disbursal"}>}Date)))'}>}AMOUNT)

Regards,

Jagan.