Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Hello all~ Please help me with a question

Hello y'all!

     i have a small question that i want to ask everyone.

This is the code i have right now:

SQL SELECT          OrderNo,

                              Weight,

                              CubedWeight,

                              Pieces,

                              DeliveryDriver

FROM CourierComplete.dbo.CompletedOrders;

this code could pull so many different results, but how do i pull something specific?

if i want only a specific DeliveryDriver, let's say..... DeliveryDriver is GTA, what would the code be??

Thank you very much!

1 Solution

Accepted Solutions

Re: Hello all~ Please help me with a question

HI

SQL SELECT          OrderNo,

                              Weight,

                              CubedWeight,

                              Pieces,

                              DeliveryDriver

FROM CourierComplete.dbo.CompletedOrders where DeliveryDriver='GTA';

or, you want to load all data but restrict the DeliveryDriver is GTA means

Load OrderNo,Weight,CubedWeight,Pieces,if(match(DeliveryDriver,'GTA',DeliveryDriver) as DeliveryDriver;

SQL SELECT   *

FROM CourierComplete.dbo.CompletedOrders

Hope it helps

4 Replies

Re: Hello all~ Please help me with a question

HI

SQL SELECT          OrderNo,

                              Weight,

                              CubedWeight,

                              Pieces,

                              DeliveryDriver

FROM CourierComplete.dbo.CompletedOrders where DeliveryDriver='GTA';

or, you want to load all data but restrict the DeliveryDriver is GTA means

Load OrderNo,Weight,CubedWeight,Pieces,if(match(DeliveryDriver,'GTA',DeliveryDriver) as DeliveryDriver;

SQL SELECT   *

FROM CourierComplete.dbo.CompletedOrders

Hope it helps

Re: Hello all~ Please help me with a question

Use Where condition in your SQL statement

SQL SELECT          OrderNo,

                              Weight,

                              CubedWeight,

                              Pieces,

                              DeliveryDriver

FROM CourierComplete.dbo.CompletedOrders

Where DeliveryDriver='GTA';

Not applicable

Re: Hello all~ Please help me with a question

Thank you very much!

Not applicable

Re: Hello all~ Please help me with a question

Thank you very much!

Community Browser