topic Re: Where condition in QlikView

Where condition

Fri, 06 Mar 2015 22:21:30 GMT

Hi QV community,

While working on QVD Generators, I need to get the data from DB table based on "Where" condition.

I have two options

1. Load *;

SQL Select * from DBTable where Month in '0315';

2. Load * where Month=0315;

SQL Select * from DBTable

Which opton works the Best?

Re: Where condition

MK_QSL — Fri, 06 Mar 2015 22:38:35 GMT

1st

Re: Where condition

Fri, 06 Mar 2015 23:06:08 GMT

Like Manish said, option 1 is better.

The main reason is because the number of records from the select statement is shortened, pulling only the necessary records. If it is a big table, then it makes even more sense.

To see how the preceding load logic works please read Simplify with Preceding Load | Qlikview Cookbook.

Hope this helps!

Kind regards,

Nuno

Re: Where condition

mukesh24 — Sat, 07 Mar 2015 10:07:44 GMT

1st Option work best

Re: Where condition

maxgro — Sat, 07 Mar 2015 10:21:58 GMT

first one but I think you have to add ( )

SQL Select * from DBTable where Month in ('0315');