SQL conditions in Qlikview

[#1]

Hi

I need to convert existing BO reports into Qlikview

There are some simple conditions mentioned in where clause of SQL like ( SELECT col1,col2 from table where table.col1='A' )ould

Should I implement these conditions at script level or it should be at UI level

[#2]

Hi Antonio,

What do you mean by level script

[antoniotiman]

Implement conditions in script (where ), don't need in Front end.

[PrashantSangle]

Hi,

You can use complete query as it is in QlikView Script.

or

you need to developed small data model based on your requirement.

Regards,

[#5]

Hi,

I have some outer joins like left outer and right outer as well in some SQL queries

Should I implement those joins as  equivalent LEFT and RIGHT JOIN in Qlikview?

[#6]

You can implement Sharma. try once

Thanks,

Nandu

[antoniotiman]

Yes, You use sintax according Your DB (SQL Server,MySql,etc.)

[#8]

Hi,

I am still not sure whether putting condition at script level for a table in SQL WHERE clause should be the correct approach as it can be possible that same table is used in another report without any WHERE condition and both reports are based on same data model