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: 
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 ?