topic Re: Help with pivot table in QlikView

data alignment in pivot tabl

qvqfqlik — Sun, 21 Aug 2016 17:16:02 GMT

Please help me with putting data into pivot table

I am trying to get data for metrics under a dates , but I am getting the dates in multiple rows(vertically)- attached P1

I need to get the date in column (horizontally) as -attached P2. Please help me tin achieving this.

Re: Help with pivot table

trdandamudi — Sun, 21 Aug 2016 17:27:46 GMT

Can you please attach a sample app which you already worked on or at least some data. Doing this will help us to help you.

Re: Help with pivot table

trdandamudi — Sun, 21 Aug 2016 17:41:23 GMT

See if the below attachment will work for you. If not can you please upload some sample data...

Re: Help with pivot table

qvqfqlik — Tue, 23 Aug 2016 18:37:51 GMT

Could you please help me with aligning the data in the pivot table ... I have attaced App and sample view to my original post.

I tried to drag the dimensions to left/right ... But it was not aligning.

sheet name "workingsheet"

I have fixed - linking two tables part. Iam able to get correct data... But unable to fix the alignment.

Re: Help with pivot table

trdandamudi — Wed, 24 Aug 2016 02:20:43 GMT

As the fields are coming from different tables, I don't think you can get the columns the way you had it in "sampleview.xls". But take a look at the attached file and see if this is ok. When you open the file take a look at the tab "sheet14".

Re: Help with pivot table

qvqfqlik — Wed, 24 Aug 2016 04:12:23 GMT

could you please tell how you combined the dates? when I copied your table into my app, the 1st column date has disappeared

Re: data alignment in pivot tabl

Anil_Babu_Samineni — Wed, 24 Aug 2016 04:52:27 GMT

What Are you expecting output

Re: data alignment in pivot tabl

qvqfqlik — Wed, 24 Aug 2016 04:54:00 GMT

I have attached sample view to the post

Re: data alignment in pivot tabl

trdandamudi — Wed, 24 Aug 2016 10:09:13 GMT

For the first column date I created a separate text box to get that date. Go to that cell and copy the text box and paste it in your app. (It is just a text box, you can move it anywhere you want... just try it...)