Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

Will "where" work in the QVD file - it does work in the SQL

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

3 Replies
josephinetedesc
Creator III
Creator III
Author

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

sunny_talwar

You can also use WildMatch here

Where WildMatch(Sts, '*1*')

josephinetedesc
Creator III
Creator III
Author

Thank you Sunny - I did not realise I had not replied.

Jo