topic Re: Convert SQL to Qlikview in QlikView

Convert SQL to Qlikview

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

Hi Community,

could you help on below..

SQL to Qlikview:

Select * from Category where

CreateDate =Case IF(DayName(ModifiedDate)='Monday' then ModifiedDate

I have tried like..

Where CreateDate = IF(WeekDay(ModifiedDate)='Mon', ModifiedDate), giving wrong result

Thanks in Advance....!

Re: Convert SQL to Qlikview

Gysbert_Wassenaar — Sat, 01 Dec 2018 08:51:00 GMT

If you are loading data from an sql database then you must use the sql dialect that your database server understands. You can't use Qlik script language because your database won't understand it.

If you're loading data from a file or another table that's already loaded then you use the LOAD statement. In that case the where clause you posted should work. If that gives a wrong result then we'll need more information. Can you post a small qlikview document that demonstrates the problem?

Re: Convert SQL to Qlikview

paulwalker — Sun, 02 Dec 2018 04:57:11 GMT

I can use same query in Qlikview, but I'm not using SQL query, some one has provided that query. I need to convert into Qlikview.

is this correct Where condition, anything wrong??

Load * from category Where CreateDate = IF(WeekDay(ModifiedDate)='Mon', ModifiedDate-3, ModifiedDate-1)

Re: Convert SQL to Qlikview

Gysbert_Wassenaar — Sat, 01 Dec 2018 11:25:30 GMT

Select * from category  Where CreateDate = IF(WeekDay(ModifiedDate)='Mon', ModifiedDate-3, ModifiedDate-1)

You are using SELECT. That means you MUST use the SQL dialect that your database server understands. Your database server DOES NOT understand Qlik script language like the WeekDay function. Therefore DO NOT USE Qlik functions in sql statements.