topic Re: SQL where operator in QlikView

SQL where operator

Anonymous — Wed, 31 Aug 2016 13:48:37 GMT

Good day!

Colleagues, is any way in QV script of using QV variable in SQL query ?

For example:

1. Current Load

Main:

Load

Period;

SQL SELECT *

FROM DataBase.dbo.DP3_Sales_Fact with (nolock)

where Period>='2016-08-01 00:00:00.000';

2.Neccessary Load

Main

Load

Period;

SQL SELECT *

FROM DataBase.dbo.DP3_Sales_Fact with (nolock)

where Period>=Current YearMonth;

In other words, in sql query i need load only Period for Current YearMonth (201608)

Thanks.

Re: SQL where operator

trdandamudi — Wed, 31 Aug 2016 14:05:39 GMT

May be as below:

Main

Load *

Where Period = '201608';

SQL SELECT *

FROM DataBase.dbo.DP3_Sales_Fact with (nolock);

Re: SQL where operator

Anonymous — Wed, 31 Aug 2016 14:15:13 GMT

Try this:

LET CurrentYearMonth = Year(today()) & month(today());

Main

Load

Period;

SQL SELECT *

FROM DataBase.dbo.DP3_Sales_Fact with (nolock)

where Period>=$(CurrentYearMonth);

Re: SQL where operator

squeakie_pig — Wed, 31 Aug 2016 14:16:08 GMT

You can also use a variable in the sql part

Main

Load *;

SQL SELECT *

FROM DataBase.dbo.DP3_Sales_Fact

where Period >= $(vCurrentYearMonth);

Re: SQL where operator

richard_chilvers — Wed, 31 Aug 2016 14:21:27 GMT

You may need to use the TODAY() with some other functions in order to get the current Year & Month.

Re: SQL where operator

vishsaggi — Wed, 31 Aug 2016 14:48:59 GMT

What is the date format in your Period field. ?

Re: SQL where operator

Anonymous — Thu, 01 Sep 2016 07:17:28 GMT

Thanks.

But Where operator in QV part of load table works longer as in SQL part.

Re: SQL where operator

Anonymous — Thu, 01 Sep 2016 07:18:05 GMT

Thanks!

Re: SQL where operator

Anonymous — Thu, 01 Sep 2016 07:18:28 GMT

'YYYY.MM.DD'

Re: SQL where operator

richard_chilvers — Thu, 01 Sep 2016 07:46:30 GMT

You might need to double-check this format.

Your original messages said the current load was :

1. Current Load

Main:

Load

Period;

SQL SELECT *

FROM DataBase.dbo.DP3_Sales_Fact with (nolock)

where Period>='2016-08-01 00:00:00.000';