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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kashfmmtz
Contributor
Contributor
‎2019-08-28 03:03 AM

Comparison of columns data and need to apply adjustment on row data on the basis of condition

Hi  All , 

I need  some  help to implement this  logic  . I  am sharing  the  data  for  only one  code  But in actual  huge  number  of  code  is  available  in my data .  I am attaching  logic  screen shot with aspect result. data  in the  below  table 

BkeyplannedActual 
420000615Jan 2019024558 
420000615Feb 2019020631 
420000615Mar 20191500027517 
420000615Apr 201916300078576 
420000615May 20197400072701 
420000615Jun 201928000  
420000615Jul 2019500000 
420000615Aug 2019970000 
420000615Sep 201900 

 

 

clipboard_image_1.png

 
383 Views
0 Likes
0 Replies