topic Re: Calculated dimension in QlikView

Calculated dimension

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have used the below logic as calculated dimension. But it gives nothing.

Logic: =if(Aggr(sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>} Sales) <0,Invoice #),Loc)

Here i need to show only the invoice # if sum (sales) < 0 as per the above condition.

Thanks..

MK_QSL — Mon, 23 Jan 2017 12:19:19 GMT

=Aggr(

If(SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) <0,Invoice #),Loc)

Updated:

=Aggr(If(SUM({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) <0,[Invoice #]),Loc)

sunny_talwar — Mon, 23 Jan 2017 12:35:51 GMT

Not entirely sure, but may be we need Invoice # in the Aggr() also unless there is a one to one relation between invoice and location.

=Aggr(If(Sum({<Date={$(varMaxDate)},flag={'eSign'},Category={'Not Complete'}>}Sales) <0,[Invoice #]), Loc, [Invoice #])