topic Re: Vertical Label With Column Data either sides in QlikView

Vertical Label With Column Data either sides

bandarjm — Sat, 16 Nov 2024 04:03:20 GMT

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

I have something like this now.

Sales	plan Mtd	ytd
Sales - A	100	2000
Sales - B	2000	777

Re: Vertical Label With Column Data either sides

dplr-rn — Mon, 25 Mar 2019 19:12:01 GMT

Need more details my friend.
Share a sample excel and desired output

Re: Vertical Label With Column Data either sides

bandarjm — Mon, 25 Mar 2019 20:41:56 GMT

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

Current:
Label	plan Mtd(Sum)	ytd(Sum)
A	100	1,000
B	2,000	20,000
C	100	1,214
D	1000	20000

Desired

plan Mtd(Sum)	Label	ytd(Sum)
100	A	1,000
2,000	B	20,000
100	C	1,214
1000	D	20000

Re: Vertical Label With Column Data either sides

dplr-rn — Mon, 25 Mar 2019 20:44:12 GMT

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

hope i didnt misunderstand

Re: Vertical Label With Column Data either sides

bandarjm — Mon, 25 Mar 2019 21:07:39 GMT

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?

Re: Vertical Label With Column Data either sides

dplr-rn — Mon, 25 Mar 2019 21:11:37 GMT

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?

Re: Vertical Label With Column Data either sides

bandarjm — Mon, 25 Mar 2019 21:14:44 GMT

Repeated like this...

Re: Vertical Label With Column Data either sides

dplr-rn — Mon, 25 Mar 2019 21:36:37 GMT

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