Cross Table -Unknow Error Issue

amit_saini — Fri, 20 Apr 2018 10:00:01 GMT

Hi Folks,

I'm calling a QVD (SAP Table) , it's having around 90 fields , but I'm interested on only below ones, So during transformation -First I have use Explicit option to get rid of Junk data and Second cross table:

In same table , we are having fields like WCO001....WCO016 and others , which are of no interest and hence been excluded.

Now I want to create a Month dimension using "WKG001 to WKG016" , logically :

WKG001 - Jan data

WKG002- Feb

....

WKG011- NOV

and last from WKG012 to WKG016 - Dec

I tried using cross table function , but it's showing "Unknown Error" message.

Please help how to categorize these "WKG..." as Month, so that I can use them as Dimm.

Thanks in advacne!

Regards,

Re: Cross Table -Unknow Error Issue

sasiparupudi1 — Fri, 20 Apr 2018 10:03:45 GMT

Crosstable(Month,Cost,4)

Re: Cross Table -Unknow Error Issue

sasiparupudi1 — Fri, 20 Apr 2018 10:31:07 GMT

can you pl paste the script and the error details?

topic Cross Table -Unknow Error Issue in QlikView

Cross Table -Unknow Error Issue

Re: Cross Table -Unknow Error Issue

Re: Cross Table -Unknow Error Issue