topic Re: Transpose in QlikView

Transpose

Tue, 14 Jul 2015 12:42:18 GMT

Hi All,

I need to transpose the Metric field values to column vise any suggestion.

Re: Transpose

sunny_talwar — Tue, 14 Jul 2015 12:46:01 GMT

Transpose them on the front end or the script?

Re: Transpose

sunny_talwar — Tue, 14 Jul 2015 12:51:39 GMT

For front end option, you can do like this:

Create a straight table
Add Metric Name, Project ID, Project Name, Updated On, Value Before Update as Dimensions
Create 1 as expression
On Presentation tab Hide 1 as expression and select Horizontal check box (attaching a screenshot for this one)

Output:

HTH

Best,

Sunny

Re: Transpose

Tue, 14 Jul 2015 13:27:13 GMT

Thankyou,

It need to be hardcoded in script Level.

Expected result is

Re: Transpose

avinashelite — Tue, 14 Jul 2015 14:21:24 GMT

Please find the attachment for the same

Re: Transpose

petter — Tue, 14 Jul 2015 14:59:28 GMT

If you are looking for a solution where you transpose (un-pivot) the table in the load script then this could be a solution for you:

I had to make your XLSX-sample conformant with your expected results so I attached a new XLSX-file too...

Re: Transpose

Mon, 20 Jul 2015 09:30:34 GMT

Hi Petter,

if i have multiple entries for same metric for same project the logic used is not working for straight table. am looking for result in straight table.