Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bandarjm
Contributor II
Contributor II

Vertical Label With Column Data either sides

img1.PNG

Trying to achieve Qlikview Straight table or Pivot. Please suggest.

I have something like this now.

Salesplan Mtdytd
Sales - A1002000
Sales - B2000777
Labels (1)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Why do you need a pivot table? On the phone so can't test it but imo you can just change the order by dragging it

View solution in original post

7 Replies
dplr-rn
Partner - Master III
Partner - Master III

Need more details my friend.
Share a sample excel and desired output
bandarjm
Contributor II
Contributor II
Author

Hope this helps... I need all my MTD  values on left side and YTD on Right side. 

Current:  
Labelplan Mtd(Sum)ytd(Sum)
A1001,000
B2,00020,000
1001,214
D100020000

 

Desired

plan Mtd(Sum)Labelytd(Sum)
100A1,000
2,000B20,000
1001,214
1000D20000

 

dplr-rn
Partner - Master III
Partner - Master III

Just change the order?
You can drag the column header and rearrange.

hope i didnt misunderstand
bandarjm
Contributor II
Contributor II
Author

I tried that. May get repeated A,B,C,D values for MTD and YTD, which i dont want.. I am trying ValueList. lets see!! any other suggestions?

dplr-rn
Partner - Master III
Partner - Master III

Not sure what you mean by repeated.
Dimension will be label And the other 2 expressions?
What happens to table when you just drag and rearrange the column? Can you share a pic?
bandarjm
Contributor II
Contributor II
Author

img2.PNG

Repeated like this...

dplr-rn
Partner - Master III
Partner - Master III

Why do you need a pivot table? On the phone so can't test it but imo you can just change the order by dragging it