topic Re: Transpose Trasnformation in QlikView

Transpose Trasnformation

Tue, 21 Jul 2015 09:43:29 GMT

Hi all ,

I have around 100 metrics in [Metric Name] field/column i want to transpose each metric into column for a straight table use.

And the table is already in QVD, when i try to transpose with 'Enable Transformation Step' application is freezing .

Please suggest me.

Re: Transpose Trasnformation

kmswetha — Tue, 21 Jul 2015 10:54:02 GMT

Hi,

After loading from QVD, use cross table function.

Re: Transpose Trasnformation

kmswetha — Tue, 21 Jul 2015 11:59:07 GMT

Hi,

me again.

You should be using generic function not crosstab once loaded from qvd.

Here is the syntax

generic load name, metric_name, (Vaue filed which ever is numeric) resident table_name;

Re: Transpose Trasnformation

Tue, 21 Jul 2015 13:24:46 GMT

Application is freezing.. Swetha

Re: Transpose Trasnformation

qlikviewwizard — Tue, 21 Jul 2015 13:51:54 GMT

Hi krrushna

Instead of loading , just edit script and run in debug mode by giving less no of rows.

Hope this will help you.

Re: Transpose Trasnformation

Tue, 21 Jul 2015 14:24:48 GMT

Its not working as expected..

Re: Transpose Trasnformation

qlikviewwizard — Tue, 21 Jul 2015 14:25:41 GMT

Can you attach the sample file.

Re: Transpose Trasnformation

Tue, 21 Jul 2015 14:40:02 GMT

Attached sample file

Re: Transpose Trasnformation

qlikviewwizard — Wed, 22 Jul 2015 03:14:42 GMT

Hi krrushna

Remove F column and second row in transformation. I used Sheet2.

Please check again. Let me know if any issues.

Re: Transpose Trasnformation

Fri, 24 Jul 2015 12:10:20 GMT

I tried this way in script. It worked for me.also i need to create this way for all other metrics.. with concatenation.

Temp:

ID,

[Updated On] as N_Updated_On,

[Value Before Update] as N_MCost Actual $

Resident [Tablename]

where [Metric Name]='MCost Actual $';

Thanks for all your suggestions.