Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IF Statements

1. I have a table where one field has a list of code (4 Number or Letters)

2. I only want to view the codes with all 4 digits being letter i.e. ABCD

3. Can I use an IF statement to change the codes <= 9999 to show as -

Excel If Statement would be;

     =IF(A1 =< 9999, "-", A1)

I'm assuming that the range above would be the 'Column Name' in QV!

Straight forward but this doesn't work as an expression against the field!!

Am I missing something here?

Thank you in advance guys

Andrew Savage

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Try with this

=IF(Num(A1) > 0, Null(), A1)

jonathandienst
Partner - Champion III
Partner - Champion III

Andrew

Try this:

If(Len(KeepChar(A1, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ')) = Len(A1), A1, '-')

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein