Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I think my syntax might need tweaking:
The SQL syntax works beautifully
FROM [dbo].[xxx]
where Sts like '%1%'
and [App_DtTm] >= '2016-09-01 00:00:00'
and (y= 9 or y= 14 or y= 16)
I then try to use QVD file tht has been created:
From QVD\SLU.qvd (qvd)
WHERE
Sts like '%1%'
and [App_DtTm2] >= 42614
and (y= 9 or y= 14 or y= 16)
;
Changing the conditions it seems that Qlikview does not like Sts like '%1%' - What is the correct syntax for Qlikview please?
Jo
Thank you all
where Sts like '*1*'
I found a link to like and wildcards - so I replaced the % with * (as in an excel query) - it worked.
Jo
You can also use WildMatch here
Where WildMatch(Sts, '*1*')
Thank you Sunny - I did not realise I had not replied.
Jo