Display rows in Straight Table conditionally

qlikvw2019 — Wed, 25 Nov 2020 16:16:04 GMT

I have a straight table , that display

col1,col2,col3,col4. I have a expression in it

=only([col4]='Not Received')

It works fine .

Now i want to add one more condition , col3='some value'

i.e col4='Not Received' AND col3='some value'

Please suggest how can i achieve it? Please let me know if i need to rewrite this entirely in the load script. Thankyou

Re: Display rows in Straight Table conditionally

dplr-rn — Mon, 24 Jun 2019 20:20:52 GMT

not completely clear on your problem but taking it at face value. did you try below

=only({<[col4]={'Not Received'},[col3]={'some value'}>}YOURCOLUMN)