Discussion Board for collaboration on QlikView Layout & Visualizations.
Find the below screen shot.
In the Source data, Ctype, from, to , product and rate fields having same data. but the Rec_No is different. I need to make the single row for the product, Rate and Rec_No should be in the row field(Pivot table).
Any tips for someone struggling to "drag up"? I continue to select the dimension but the blue arrow continues to point upwards instead of sideways no matter where I drag it.
Also is there any way to do this without the dragging feature? In properties maybe?
No other way to do this I'm afraid. Select and hold the mouse button and you get the blue arrow, when you 'drag up' take your mouse first into the expression area (the red box) and then up into the expression labels(up the red arrow) and it should change to a sideways arrow for you.
You might need to keep dragging up beyond the labels and outside the chart. it can be a bit funny at times to register the movement.
hope that helps