topic How to use Crosstable-function in QlikView

How to use Crosstable-function

Fri, 04 Mar 2011 12:08:16 GMT

Hello all,

Im trying to use the function Crosstable but I dont get it right. The attached picture shows my source and what im trying to acheive. It doesnt necesary need to be done with crosstable-function. (I dont want to do this in an object because I have to use it in other calculations in my script.)

All help and tips are appreciated.

Cristian

How to use Crosstable-function

deepakk — Fri, 04 Mar 2011 12:11:35 GMT

hi ,

Use the below code.

Crosstable(Account , Value,1)

Load

Year,

Accoun_1,

Account_2

....... from table;

How to use Crosstable-function

Fri, 04 Mar 2011 12:19:30 GMT

Thanks for your help Deepak but this results in three columns - Year, Account, Value. I would like one column per year -> Account, Year1, Year2, Year3, Year4, Year5.

Cristian

How to use Crosstable-function

deepakk — Fri, 04 Mar 2011 12:22:26 GMT

hi,

Now in pivot table add Account and Year in dimension and Value in Expression . then right click and expand all...

Drag the year to top of the value field. You will get the required output.

How to use Crosstable-function

Fri, 04 Mar 2011 12:29:12 GMT

Yes, but I dont want to solve this in an object. I already have it in an object. I need to solve in my script. Is it possible?

Cristian

How to use Crosstable-function

deepakk — Fri, 04 Mar 2011 13:02:04 GMT

hi Critian,

PFA

How to use Crosstable-function

Fri, 04 Mar 2011 13:55:32 GMT

Thank you! This works great!

Cristian