Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master III

Cross Table -Unknow Error Issue

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:

Capture.PNG

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,

AS

1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

Crosstable(Month,Cost,4)

View solution in original post

2 Replies
sasiparupudi1
Master III
Master III

Crosstable(Month,Cost,4)

sasiparupudi1
Master III
Master III

can you pl paste the script and the error details?