Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

multiple 'AND' inside IF

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

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Esteemed Contributor II

Re: multiple 'AND' inside IF

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

View solution in original post

4 Replies
Highlighted
Esteemed Contributor II

Re: multiple 'AND' inside IF

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

View solution in original post

Highlighted
MVP
MVP

Re: multiple 'AND' inside IF

Like this

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
New Contributor III

Re: multiple 'AND' inside IF

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

Highlighted
Esteemed Contributor II

Re: multiple 'AND' inside IF

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.