Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bazzaonline
Creator
Creator

Cross Table or something else?

Hello,

Im trying to load an excel spreadsheet with data but need to transpose some of columns so I get a really simple table in qlik, is this possible?

Excel Input      
Field 1Field 2Field 3 JanFebMarApr 
adg1251 
beh7324 
cfi4824 
        
        
Qlik Table      
Field 1       
Field 2       
Field 3        
Months       

 

Thanks in advance

1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try using Crosstable()

image.png

 

CrossTable(Month, Value,3)
LOAD * Inline [
Field 1,Field 2,Field 3,Jan,Feb,Mar,Apr	 
a, d, g, 1, 2, 5, 1
b, e, h, 7, 3, 2, 4
c, f, i, 4, 8, 2, 4]
;

 

View solution in original post

3 Replies
Vegar
MVP
MVP

Try using Crosstable()

image.png

 

CrossTable(Month, Value,3)
LOAD * Inline [
Field 1,Field 2,Field 3,Jan,Feb,Mar,Apr	 
a, d, g, 1, 2, 5, 1
b, e, h, 7, 3, 2, 4
c, f, i, 4, 8, 2, 4]
;

 

bazzaonline
Creator
Creator
Author

Briiliant, really helpful.  Is there anyway I can change the month field as its pulling through as a numberic field?

Vegar
MVP
MVP

I'm sorry, but I don't really understand your issue. Could you try to post a picture or explain again in other words?