if text field is not null then..

[tinkerz1]

Hi.

Really finding this one difficult.

I am imported a spreadsheet and I am using a straight table with the following expression that I can get to work

If(isnull(comment)=false,[group]={'Open-HL'}

I am trying to only list all comments that are not null in a table and bring back where the group is 'Open=HL'

Really cant see it.

Thanks

[giakoum]

if(isnull(comment) and [group]<>'Open-HL', null(), [group])

[Anonymous]

Try this

If(isnull(comment),[group],

[sinanozdemir]

They might be blank values rather than NULL.

If(comment <> ''

[Gysbert_Wassenaar]

Try this expression: minstring({<comment={'*'},group={'Open-HL'}>}comment)

[tinkerz1]

sorry it was if comment was not blank or empty

comment<>"" does not work for me

[giakoum]

try a combination of len and trim. but it would be easier if you could post a sample app

[tinkerz1]

its just two columns in a spreadsheet, one is reference numbers in the style ABC123 and the comment is either blank or not, just test for a newbie to qlikview.

Thanks

[giakoum]

just post the excel with a few sample rows

there might be spaces or special characters we need to consider

[tinkerz1]

Hi,

Sorry I can only paste here and example from excel 2010, I am surprised the formula Commentry<>"" does not work but a min search on lenght is more accuate to search on.

Group	Date of Update	REF	Comment	Priority
OPEN	01/12/2013	Ref1	Commentry1	1
OPEN	01/12/2013	Ref2	Commentry2	1
OPEN	01/12/2013	Ref3	Commentry3	1
OPEN	01/01/2014	Ref4	Commentry4	1
OPEN	01/01/2014	Ref5	Commentry5	1
OPEN	01/01/2014	Ref6	Commentry6	1
OPEN	01/02/2014	Ref7	Commentry7	2
OPEN	01/02/2014	Ref8	Commentry8	2
OPEN	01/02/2014	Ref9	Commentry9	2
OPEN	01/03/2014	Ref10	Commentry10	1