topic Re: Trans in QlikView

Trans

Mon, 02 Nov 2015 10:49:54 GMT

we are getting data like this

I don't want to do any changes in excel

But I need to convert data like this in QV

Re: Trans

Anonymous — Mon, 02 Nov 2015 10:52:06 GMT

You are talking about Excel or Qlikview??

Re: Trans

Anonymous — Mon, 02 Nov 2015 10:53:25 GMT

If it is in QV, you can use CrossTable feature to achieve same.

Share the sample Data.

Re: Trans

sasikanth — Mon, 02 Nov 2015 10:54:34 GMT

HI,

Try "Enabling Transformation" Step in Qlikview while loading your Excel data .

Re: Trans

prma7799 — Mon, 02 Nov 2015 10:56:33 GMT

Hi Naveen,

Can you please send some sample file.

Thanks

Re: Trans

Mon, 02 Nov 2015 11:09:52 GMT

First table is Excel(Data source)

second table is I need show in QV

Re: Trans

Anonymous — Mon, 02 Nov 2015 11:12:06 GMT

Then use Cross Table to fetch it into QV.

Once it is in QV you can show it in your own way.

Re: Trans

prma7799 — Mon, 02 Nov 2015 11:26:12 GMT

Two ways to do

1.Enabling Transformation

2.Cross Table functionality

Better you send at least excel file.

Thanks

Re: Trans

Peter_Cammaert — Mon, 02 Nov 2015 11:35:43 GMT

An excellent example on how to process this type of multiheader-pivot is to be found here: multi_header_pivot_import.qvw

Best,

Peter

Re: Trans

Mon, 02 Nov 2015 12:30:31 GMT

I attached Sample data....Friends

Try it and send me updates

Re: Trans

Tue, 03 Nov 2015 04:06:31 GMT

Hi Peter,

can u please solve this.......

urgent requirement