Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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