issue on condtion

[prashanth1712]

hi I have requirement like this please help me on this

if bank='c' and

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.

My Fields

Acount Num

Account code

[hemanthaanichet]

Hi Reddy

Can U provide  sample data so that i can work on that.

As per my understanding

if(Account code=?? ,max([Account Name), [Account Name])

?? - using a column name or some valid related data column/Field

Regards,

Hemanth

[Anil_Babu_Samineni]

For These, If you share application that's great help

a) If(bank = 'c' and GetFieldSelections(FD) >0, Max([Acc_Num]))

b) GetFieldSelections(DD) >0, Max([Acc_Num])

[prashanth1712]

i need to write a and b part in single condition and also need to implement in scripting side

[Anil_Babu_Samineni]

Like This, Can you confirm me one thing FD and DD are single field Values?

If(bank = 'c' and GetFieldSelections(FD) >0, Max([Acc_Num]), If(GetFieldSelections(DD) >0, Max([Acc_Num]))

OR

If FD, DD values are on same field

If(bank = 'c' and '('& Concat(GetFieldSelections(FieldName),'|') &')', Max([Acc_Num]))

[qlikviewwizard]

Hi prashanth1712,

Can you share a sample application.