topic Re: multiple 'AND' inside IF in QlikView

multiple 'AND' inside IF

Anonymous — Tue, 07 Feb 2017 03:50:53 GMT

Hey! I am trying to create following formula. but it doesnt work. can anybody help please?

=If((1< Overdue Days AND Overdue Days <31 AND Current Status = ('01 OR '1') AND Balance > 0),'1-30 DAYS')

Re: multiple 'AND' inside IF

vinieme12 — Tue, 07 Feb 2017 05:19:17 GMT

=If((1< Overdue Days AND Overdue Days <31 AND wildmatch(Current Status,'01','1') AND Balance > 0),'1-30 DAYS')

Re: multiple 'AND' inside IF

jonathandienst — Tue, 07 Feb 2017 05:19:53 GMT

Like this

=If((1 < Overdue Days And Overdue Days < 31 And Num(Current Status) = 1 And Balance > 0), '1-30 DAYS')

Re: multiple 'AND' inside IF

Anonymous — Tue, 07 Feb 2017 06:33:35 GMT

thank you. that's exactly what I'm looking for

Re: multiple 'AND' inside IF

vinieme12 — Tue, 07 Feb 2017 06:36:14 GMT

Your Welcome

Use wildmatch for multiple values, but if you just want to match a single number stored as text you can also consider using NUM() as Jonathan has demonstrated.