topic Re: Due Amount ? in QlikView

Due Amount ?

Tue, 11 Nov 2014 11:12:51 GMT

HI All,

I have implemented the Due Amount Logic as on Today ,

I have Year & Month...

If user Select Current Month & Current Year that Value Should be display... Other then Current Year & Current MOnth that field Should show NA (Not applicable)...

Help me on this...

regards,

Heather

Re: Due Amount ?

PrashantSangle — Tue, 11 Nov 2014 11:16:09 GMT

Hi,

Made it conditional

use condition like

if(month=month(today()) and Year=Year(today()),1,0)

Regards

Re: Due Amount ?

its_anandrjs — Tue, 11 Nov 2014 11:29:41 GMT

Hi,

Provide any sample file for this or you can try like create a field in the load script

Load

if(Month = Max(Month) and Year = Max(Year) ,'NA', [Due Amount]) as [Due Amount Details]

From Source;

Regards

Anand

Re: Due Amount ?

Tue, 11 Nov 2014 11:30:04 GMT

if(month=max(month) and year=max(year),1,0)