topic How to use Qlikview Cross table into SQL Server in QlikView

How to use Qlikview Cross table into SQL Server

Tue, 08 Oct 2013 09:24:08 GMT

I have a qlikview script which used cross table for make table. My requirement is I want to run this script to SQL Server. But SQL not

reads cross table, so how can I run this script into SQL Server. Please help me to resolve this.

Thanks In Advance ...

Re: How to use Qlikview Cross table into SQL Server

israrkhan — Tue, 08 Oct 2013 09:30:39 GMT

Dear Ahmad,

will you elaborate a bit more, did bot get you.

you have qlikview cross table script, you generated it by????

Re: How to use Qlikview Cross table into SQL Server

v_iyyappan — Tue, 08 Oct 2013 09:40:06 GMT

Hi,

If u want use cross table in sql server. please refer this link

Sql Server 2008 Cross Tab Query - Stack Overflow

SQL Server CROSS APPLY and OUTER APPLY

hope its help

regards,

Re: How to use Qlikview Cross table into SQL Server

jagan — Tue, 08 Oct 2013 09:47:40 GMT

Hi,

Use UnPivot option in SQL Server

http://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query

http://blogs.msdn.com/b/mab/archive/2008/06/16/sql-server-2005-unpivot-command-changings-columns-to-rows-normalizing.aspx

Regards,

Jagan.

Re: How to use Qlikview Cross table into SQL Server

Gysbert_Wassenaar — Tue, 08 Oct 2013 09:53:09 GMT

You can't use Qlikview funtions in sql statements. If the statement should be executed by SQL Server then you need to use the Pivot function of SQL Server: Using PIVOT and UNPIVOT

Re: How to use Qlikview Cross table into SQL Server

Tue, 08 Oct 2013 10:19:18 GMT

Dear Israr,

Thanks for ur quick reply ...

I am trying to generate SQL Script by the use of Qlikview Script without changing any out put data.

Now I am sending Qlikview Script, It will help u to understand

Crosstable(MOPDay,[Sales MOP value],7)

MOPTemp:
LOAD

    D_CODE,

     M_CODE,

     VARIANT,

     TYRE,

     FINYEAR,

     FINMONTH,

     AOPQTY,

     Num(D1) as 1,

    Num(D2) as 2,

     Num(D3) as 3,

     Num(D4) as 4,

     Num(D5) as 5,

     Num(D6) as 6,

     Num(D7) as 7,

     Num(D8) as 8,

     Num(D9) as 9,

     Num(D10) as 10,

     Num(D11) as 11,

     Num(D12) as 12,

     Num(D13) as 13,

     Num(D14) as 14,

    Num(D15) as 15,

     Num(D16) as 16,

     Num(D17) as 17,

     Num(D18) as 18,

     Num(D19) as 19,

     Num(D20) as 20,

     Num(D21) as 21,

     Num(D22) as 22,

     Num(D23) as 23,

     Num(D24) as 24,

     Num(D25) as 25,

     Num(D26) as 26,

    Num( D27) as 27,

     Num(D28) as 28,

     Num(D29) as 29,

     Num(D30) as 30,

     Num(D31) as 31


FROM

[$(Rawqvdpath)\C_PLAN.qvd]

(qvd);