topic Re: How to change bellow Scenario in QlikView

How to change bellow Scenario

kulasekhar — Fri, 17 Apr 2015 06:53:37 GMT

Hi All,

Scenario: Product in one column, different dates in different columns

Data : provided in attached excel file.

Product	12-Apr	13-Apr	14-Apr	15-Apr
P1	100	200	200	700
P2	200	100	300	100
P3	300	300	400	300
P4	400	400	500	400
P5	500	600	600	600
P6	600	700	700	400
P7	700	100	100	500

Result should display as :

Thanks,

Thimma

Re: How to change bellow Scenario

PrashantSangle — Fri, 17 Apr 2015 07:00:46 GMT

Hi,

Do you want in script???

If yes do transpose while loading data. in Enable Loading Transformation step->Rotate

Regards

Re: How to change bellow Scenario

nagarjuna_kotha — Fri, 17 Apr 2015 07:03:34 GMT

Hi,

Use Transpose when u r loading .

Regards,

Nagarjuna

Re: How to change bellow Scenario

Marcellino_Groothof — Fri, 17 Apr 2015 07:05:34 GMT

Hi,

Read the table file, header size = lines, then push button NEXT, then transpose.

Greetings,

Marcellino

Re: How to change bellow Scenario

ganeshreddy — Fri, 17 Apr 2015 07:23:59 GMT

Hi Shekhar,

Do following steps,

1. while loading select enable transformation

2. select rotate.

3 .apply transpose and the press right.

you will get your desired result.

Cheers,

Ganesh

Re: How to change bellow Scenario

jonathandienst — Fri, 17 Apr 2015 08:29:10 GMT

You need a cross table load to get the dates and product names as fields:

Temp:

CrossTable(Date, Amount, 1)

LOAD * FROM ....xls;

Final:

LOAD Product,

Date(Date#(Date, 'dd-mmm')) As Date, // gets date as a numeric QV date

Amount

Resident Temp;

DROP Table Temp;

Then create a straight table with Date and Product as dimensions and Sum(Amount) as the expression

HTH

Jonathan

Re: How to change bellow Scenario

kulasekhar — Fri, 17 Apr 2015 08:32:28 GMT

Thanks for ever one. giving solution.

Thanks

sekhar

Re: How to change bellow Scenario

buzzy996 — Fri, 17 Apr 2015 08:38:34 GMT

pfa,hopes this also helps just created using cross table.