Due Amount ?

Report Inappropriate Content · ‎2014-11-11

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

PrashantSangle · ‎2014-11-11

Hi,

Made it conditional

use condition like

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

its_anandrjs · ‎2014-11-11

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

Report Inappropriate Content · ‎2014-11-11

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

Related Topics