Need help on if condition

prashanth1712 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Need help on if condition

lakshmikandh — Tue, 08 Nov 2016 06:36:25 GMT

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

Re: Need help on if condition

varshavig12 — Tue, 08 Nov 2016 08:23:53 GMT

Can you provide some sample data with expected output ?

topic Re: Need help on if condition in QlikView

Need help on if condition

Re: Need help on if condition

Re: Need help on if condition