topic Where statement in load script won't work in QlikView

Where statement in load script won't work

Thu, 11 Sep 2014 14:42:50 GMT

Hi,

I have a where function in the scirpt below. But it don't work. Has you some ideas how to fix this?

The is imported of a mssql server environment.

rept_category_navigation:

Load

// site as land,

"super_category_display_name" as super_category,

main_category_display_name as main_category,

category_unique_name as unique_name,

category_hidden,

super_category_hidden,

main_category_hidden

from "Reporting_db".dbo."rept_category_navigation"

where((category_hidden='0') OR (super_category_hidden='0') OR (main_category_hidden = '0'));

Re: Where statement in load script won't work

marcus_sommer — Thu, 11 Sep 2014 15:12:32 GMT

'0' is a string - maybe you need it numerical without quotes.

- Marcus

Re: Where statement in load script won't work

vgutkovsky — Thu, 11 Sep 2014 15:24:48 GMT

Shouldn't it be "SELECT" instead of "LOAD"? LOAD is a QV-specific keyword and you're loading from a DB it seems.

Vlad

Re: Where statement in load script won't work

IAMDV — Thu, 11 Sep 2014 20:44:24 GMT

Vlad is right. Looks like you're mixing ANSI SQL code with the LOAD statement. Clearly you're referencing the database name, schema name and object name.

You need somthing like this:

Load *;

SELECT

// site as land,

"super_category_display_name" as super_category,

main_category_display_name as main_category,

category_unique_name as unique_name,

category_hidden,

super_category_hidden,

main_category_hidden

from "Reporting_db".dbo."rept_category_navigation"

where((category_hidden='0') OR (super_category_hidden='0') OR (main_category_hidden = '0'));