Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ...
Dear Ahmad,
will you elaborate a bit more, did bot get you.
you have qlikview cross table script, you generated it by????
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,
Hi,
Use UnPivot option in SQL Server
http://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query
Regards,
Jagan.
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
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);