Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
kaviyarasan
Contributor
Contributor

Current month data should up arrow when compare to previous month data not available in source file

Current Scenario:

Currently i'm taking month(o4) from Date (i.e 12.04.2019).but problem is i couldn't able to get month if data available in  the source.

case 1: Up Arrow

if current month > Prev Month

case 2: Down Arrow

if current month < Prev Month

Expected output:

case 3: Up Arrow

current month should show up arrow if prev month data is not available in source file

1 Reply
Channa
Specialist III
Specialist III

can you share your current expression..

try if(isnull(currentMonth),up,down)

Channa