Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
prashanth1712
Contributor III
Contributor III

Need help on if condition

a) For FD Section, the Account num should take from the cv_Table (pick highest value).

b) DD section - the Account num should take from the cv_Table (pick highest value).

Note:  after following the above rules, if the account having null value or spaces, then :-

a) If the person having single Account in CV_table then load it with same Account from Cv_table (i.e. Acc_Num from cv_Table)

b)  If the person having multiple Accounts in CV_table, then default it to the first Account no from CV_table  after sorting all the Account numbers in descending order.

For eg- If we have accounts  – 620620 and 620622, then use the Account num as 620622. While defaulting, sort "descending" order meaning the "highest" numbered

Account will be used for the default.

2 Replies
lakshmikandh
Specialist II
Specialist II

Your question is not clear , what you want to do? Can you attached sample data ?

varshavig12
Specialist
Specialist

Can you provide some sample data with expected output ?