Discussion board where members can get started with Qlik Sense.
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.
Check out Not IsNull(FieldName)
Thanks Marmentrous5 but it does not work
Can u try like.
Not IsNull([Customer Rating]) And Trim([Customer Rating])<>'' And Len([Customer Rating])>0 And [Customer Rating]<5
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
The above is wrong. May be..
=Not IsNull([CusSat Rating]) And Len([CusSat Rating])>0 And [CusSat Rating]<5