topic Re: Need script help! in QlikView

Need script help!

Anonymous — Sun, 26 Oct 2014 17:59:49 GMT

I have a raw data table looking like this:

Motordata:

ID Row Value

7760 1 10

7760 2 20

7760 3 30

7760 4 40

7760 5 50

7760 6 60

7760 7 70

7760 8 80

7760 9 90

7760 10 100

7761 1 10

7761 2 20

7761 3 30

And so on...

How do i need to write the script to make it look like this:

ID Value1 Value2 Value3 Value4 Value5 Value6 Value7 Value8 Value9 Value10

7760 10 20 30 40 50 60 70 80 90 100

7761 10 20 30 and so on...

Looking forward to hear from you guys!

Regards/Patric

Re: Need script help!

its_anandrjs — Sun, 26 Oct 2014 18:12:55 GMT

Write the expression in any Pivot chart for this will be better

Take dimensions

Dimension1:- ID

Dimension2:- Row

Expression:- Sum(Value)

And you get pivot chart like

For doing this you can click on the Row dimension and drag to the upper right corner of the pivot chart and when it comes as horizontal then leave it there.

Regards,

Anand

Re: Need script help!

ashfaq_haseeb — Sun, 26 Oct 2014 18:15:50 GMT

Like this.

have a look at attached application.

Regards

ASHFAQ

Re: Need script help!

maxgro — Sun, 26 Oct 2014 18:20:20 GMT

also with generic load

Motordata:

load * inline [

ID , Row , Value

7760 , 1 , 10

7760 , 2 , 20

7760 , 3 , 30

7760 , 4 , 40

7760 , 5 , 50

7760 , 6 , 60

7760 , 7 , 70

7760 , 8 , 80

7760 , 9 , 90

7760 , 10 , 100

7761 , 1 , 10

7761 , 2 , 20

7761 , 3 , 30

];

Table:

Generic load ID , Row , Value Resident Motordata;

DROP Table Motordata;

Re: Need script help!

maxgro — Sun, 26 Oct 2014 18:23:29 GMT

and also with

Table:

load ID, Value as Value1 Resident Motordata where Row=1;

join (Table) load ID, Value as Value2 Resident Motordata where Row=2;

join (Table) load ID, Value as Value3 Resident Motordata where Row=3;

join (Table) load ID, Value as Value4 Resident Motordata where Row=4;

.....

join (Table) load ID, Value as Value10 Resident Motordata where Row=10;

DROP Table Motordata;

Re: Need script help!

its_anandrjs — Sun, 26 Oct 2014 18:32:02 GMT

Or by any calculated dimension you can achieve this like add the dimension for ROW

Dimension1:- ID

Dimension2:-

=IF(Row=1,'Value 1',

IF(Row=2,'Value 2',

IF(Row=3,'Value 3',

IF(Row=4,'Value 4',

IF(Row=5,'Value 5',

IF(Row=6,'Value 6',

IF(Row=7,'Value 7',

IF(Row=8,'Value 8',

IF(Row=9,'Value 9',

IF(Row=10,'Value 10',

))))))))))

Expression:- Sum(Value)

And you get

Regards,

Anand

Re: Need script help!

Anonymous — Sun, 26 Oct 2014 20:15:08 GMT

Thanks to all for the helpful answers!

Massimo´s answer was the one i was looking for to get the script woorking as i want.

Thanks again!!!

Regards/Patric

Re: Need script help!

its_anandrjs — Sun, 26 Oct 2014 20:20:32 GMT

Hi Patric,

And rest of the answers it will not help you, did you check calculated dimension also.

Regards,

Anand

Re: Need script help!

Anonymous — Wed, 29 Oct 2014 21:24:14 GMT

Hi Anand

The solution i was looking for was to use in the script not in a chart..

I needed the script to create a table with a key that joind it to Another table.

Thanks a lot for trying to help me!

Regards/Patric