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: 
Not applicable

crosstable faillure if header field is nummeric

I have a prolbem with my flexible crosstable

If the header is a nummeric value he doesn't work.

Has anyone a suggestion to fix this problem?

For example

My table looks like

Header 1Header 2Header 3
01020
104567
204689

The yellow field is my height header

If it has the value A for example, everything works. But with a nummeric value, he can't make my height dimmension

My script for the crosstable is like:

 

Sub SubCrossTable
    
Directory;
     Temp_CrossTable:
    
CrossTable(Breedte, Prijs)
    
LOAD
     *

    
FROM
    
$(vExcelDocument)
     (
biff, embedded labels, table is $(vExcelTab)$, filters(
    
Remove(Row, RowCnd(Interval, Pos(Top, $(vBovenBegin)), Pos(Top, $(vBovenEind)), Select(1, 0))),
    
Remove(Row, RowCnd(Interval, Pos(Top, $(vOnderBegin)), Pos(Bottom, $(vOnderEind)), Select(1, 0)))
     ));
    
    
     Prijzen:
    
load
     '$(vProductGroep)'&'#'&'$(vUitvoering)'&'#'&'$(vCollectie)'&'#'&'$(vPrijsGroep)'
as SLT_PrijsGroep,
    
$(vPrijsGroep) as Hoogte,
    
Breedte,
    
Prijs
    
Resident Temp_CrossTable;
    
drop table Temp_CrossTable;
End Sub

Who can help me with this question.

Regards,

Dirk

0 Replies