Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

SQL Script in Qlikview - Where Clause and Top1

Hi I have the following code snippet in SQL and am looking to use it in my QLikview script.

however when applying directly into SQL it returns an error.

1. How to use a clause statement WHERE ?

2.How to use function TOP in script?

Any tips would be appreciated;

See code snippet below;

SELECT

TOP 1 updated, updatedby
From dboxxxxxx ."tblCase_CaseHistory";
WHERE caseid = ärendeid AND statusid IN (avslutadstatusid)

1 Solution

Accepted Solutions
perumal_41
Valued Contributor II

Re: SQL Script in Qlikview - Where Clause and Top1

Hi

try below script

First (1) Select * from Orders

1 Reply
perumal_41
Valued Contributor II

Re: SQL Script in Qlikview - Where Clause and Top1

Hi

try below script

First (1) Select * from Orders

Community Browser