Where condition

[#1]

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?

[MK_QSL · Accepted solution]

1st

[#3]

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

[mukesh24]

1st Option work best

[maxgro]

first one but I think you have to add ( )

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