topic Re: Referencing a column in set analysis in QlikView

Referencing a column in set analysis

Mon, 09 Mar 2015 07:31:32 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

Re: Referencing a column in set analysis

linusblomberg — Mon, 09 Mar 2015 07:36:35 GMT

why don't enter the expression for [Last date] instead. I've never tried to reference a column in set analysis but I usually make variables for my expressions already in the load script and that will work for you.

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

Re: Referencing a column in set analysis

jagan — Mon, 09 Mar 2015 08:00:02 GMT

Hi,

The calculations are done at chart level, not by row by row. So we cannot use the Expression name in the Set analysis, instead you can below expression

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

** If the above expression then check for the date format of Date column and =Date(max({<Flag={"Disbursal"}>}Date)), both should be in the same format.

Regards,

Jagan.

Re: Referencing a column in set analysis

Mon, 09 Mar 2015 09:25:46 GMT

Thanks its work

Re: Referencing a column in set analysis

jagan — Mon, 09 Mar 2015 09:29:32 GMT

Hi,

If you got the answer please close this thread by giving Correct and Helpful answers to the useful posts.

Regards,

Jagan.