topic Re: issue on condtion in QlikView

issue on condtion

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

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

Re: issue on condtion

hemanthaanichet — Tue, 08 Nov 2016 04:54:15 GMT

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

Re: issue on condtion

Anil_Babu_Samineni — Tue, 08 Nov 2016 05:03:22 GMT

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])

Re: issue on condtion

prashanth1712 — Tue, 08 Nov 2016 06:16:47 GMT

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

Re: issue on condtion

Anil_Babu_Samineni — Tue, 08 Nov 2016 06:39:44 GMT

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]))

If FD, DD values are on same field

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

Re: issue on condtion

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

Hi prashanth1712,

Can you share a sample application.