Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
QlickySense
Creator
Creator

How to add new column in crosstable

Hi,

I am trying to add new column to crosstable, however it appears that its always goes under "y value"

CROSSTABLE(x,y)
Load
cust_ID,
vVar1,

vVar2,

vVar3,
vVarCalculated

Resident TableX;

 

What is currently(vVarCal is weighted value)

ID X Y
ID1 vVar1 Value of vVar1
ID1 vVar2 Value of vVar2
ID1 vVar3 Value of vVar3
ID1 vVarCalculated vVarCalculated

 

What I would like to achieve

ID X Y vVarCalculated
ID1 vVar1 Val of vVar1 Val of vVarCal
ID1 vVar2 Val of vVar2 Val of vVarCal
ID1 vVar3 Val of vVar3 Val of vVarCal

 

Is it something I can do or its limited to only X and Y?

Labels (2)
1 Reply
MayilVahanan

Hi

Try like below

CROSSTABLE(x,y, 2)
Load
cust_ID,

vVarCalculated,
vVar1,

vVar2,

vVar3

Resident TableX;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.