Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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';

Highlighted
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!