Solved: If Condition in where clause - Qlik Community - 781390

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

Hi There,

Can we use If condition in where clause?

If yes could plz share the example with syntax

Thanks,
DJ

1 Solution

Accepted Solutions

Hi

Not sure that I understand. A WHERE clause is already a type of if:

LOAD ....

FROM .....xlsx (ooxml, ...)

Where Len(Code) > 0;

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies

see the sample .

Hi

Not sure that I understand. A WHERE clause is already a type of if:

LOAD ....

FROM .....xlsx (ooxml, ...)

Where Len(Code) > 0;

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

may be he wants to select the condition of where depending on a if result . its useful if we use a parameter file (with variables)