Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

If statement

Hello everyone,

I need to create a table to show customer satisfaction rating on a daily basis that is not null(or -) and less than 5. I already created the table but it shows ratings that are null and some that have a rating > 4. Thanks for your suggestions.

5 Replies
Highlighted
Creator
Creator

Check out Not IsNull(FieldName)

Highlighted
Creator II
Creator II

Thanks   Marmentrous5  but it does not work

Highlighted
Specialist III
Specialist III

Can u try like.

Not IsNull([Customer Rating]) And Trim([Customer Rating])<>'' And Len([Customer Rating])>0 And [Customer Rating]<5
Highlighted
Creator II
Creator II

Thanks but I get only zeros. Not what am looking for. Below is the set expression I used

=Not IsNull([CusSat Rating])<>'' And Len([CusSat Rating])>0 And [CusSat Rating]<5

Highlighted
Specialist III
Specialist III

=Not IsNull([CusSat Rating])<>'' And Len([CusSat Rating])>0 And [CusSat Rating]<5

The above is wrong. May be..

=Not IsNull([CusSat Rating]) And Len([CusSat Rating])>0 And [CusSat Rating]<5