topic Re: Re: Syntax Qlikview in Water Cooler

Syntax Qlikview

Mon, 05 May 2014 14:47:58 GMT

Hello,

I'm new in QlikView . Can you help me to adapt this SQL for QlikView?

PEDIDOS FINALIZADOS:

SELECT IPD_NUMPED FROM ITPEDIDOS

WHERE IPD_CDEMP = 1

AND IPD_TPPED = 'V'

GROUP BY IPD_NUMPED

HAVING SUM(IPD_BASE) > 0

PEDIDO PENDENTE TOTAL (NENHUMA QUANTIDADE ENTREGUE)

SELECT IPD_NUMPED FROM ITPEDIDOS

WHERE IPD_CDEMP = 1

AND IPD_TPPED = 'V'

GROUP BY IPD_NUMPED

HAVING SUM(IPD_QTDENT) =0 AND SUM(IPD_BASE) = 0

Thanks.

Re: Hello, I'm new in QlikView . Can you help me to adapt this SQL for QlikView?

SunilChauhan — Mon, 05 May 2014 14:49:39 GMT

Create connection string using OLeDb and use direct below query

and reload it will give your result

Re: Syntax Qlikview

bbi_mba_76 — Mon, 05 May 2014 14:54:18 GMT

Hi,

in the first query you are selecting only a field (IPD_NUMPED).

Try with select * from....

Re: Syntax Qlikview

IAMDV — Mon, 05 May 2014 15:00:51 GMT

Hi,

Not sure what you mean by adapt in QlikView? Do you want to re-write the same query in QlikView or do you want to use the SQL query in QlikView? Please clarify.

Thanks,

www.QlikShare.com

Re: Syntax Qlikview

Mon, 05 May 2014 16:39:48 GMT

Hi,

Deepak, I want to re-write the same query in QlikView. This query returns a message to the User: "Pedido Finalizado" and need to do the same in QlikView

Re: Re: Syntax Qlikview

IAMDV — Mon, 05 May 2014 19:39:11 GMT

Hi,

Thanks for clarifying! Here we go...

Bad News: There is NO Having clause in QlikView

Good News: We can still solve this by using Where clause and the Preceding Load.

I've made a video tutorial sometime back and hopefully it will answer your question.

http://qlikshare.com/qlikview-video-tutorial-clause-qlikview/

However, you syntax will look something like this...

//This is Preceding Load

LOAD

WHERE IPD_BASE >0;

// This is main Load

LOAD

IPD_NUMPED,

SUM(IPD_BASE) AS IPD_BASE

From ITPEDIDOS

WHERE

PD_CDEMP = 1

AND IPD_TPPED = 'V'

FROM TableName

GROUP BY IPD_NUMPED;

I hope this helps!

Cheers,

Re: Syntax Qlikview

Mon, 05 May 2014 21:00:34 GMT

Thank you for the help! I'll watch the video ...

Re: Syntax Qlikview

Tue, 06 May 2014 18:40:38 GMT

Thank you Deepak, I got the result I needed!!

Re: Re: Syntax Qlikview

IAMDV — Tue, 06 May 2014 19:48:20 GMT

I'm glad to know that you got it working. Good luck!

Cheers,