Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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