topic Re: Dynamic columns in table. in QlikView

Dynamic columns in table.

Anonymous — Thu, 08 Nov 2012 17:48:51 GMT

Hello,

Let's say we have following input set:

A 2000 1

B 2000 2

A 2001 5

B 2001 4

A 2002 2

B 2002 8

I need someting similar to Time Chart Wizard which will generate report:

2000 2001 2002

A 1 5 2

B 2 4 8

but the key thing is that with wizard I'm forced to add all columns ( 2000, 2001, 2002 ) manually.

Is there any better way to do that and automate that process to avoid "clicking". If we have 3 columns

it makes no difference, but when we are close to 50 it's getting painful ?

Re: Dynamic columns in table.

MayilVahanan — Thu, 08 Nov 2012 18:01:06 GMT

PFA

Are you looking like this?

Re: Dynamic columns in table.

Fri, 09 Nov 2012 09:44:34 GMT

Hello ,

but if i have this table :

A 2000 d1

B 2000 d2

A 2001 d5

B 2001 d4

A 2002 d2

B 2002 d8

and i want :

2000 2001 2002

A d1 d5 d2

B d2 d4 d8

How i can do it?

Thank

Wava

Re: Dynamic columns in table.

jagannalla — Fri, 09 Nov 2012 10:10:47 GMT

Hello,

This can be done by Generic Load. Here is the script.

T1:
LOAD * INLINE [
    F1, F2, F3
    A, 2000, 1
    B, 2000, 2
    A, 2001, 5
    B, 2001, 4
    A, 2002, 2
    B, 2002, 8
];
Generic LOAD F1,F2,F3 Resident T1;

- Take the table box and add F1,2000,2001,2002 and you will see the below result.

F1	2000	2001	2002
A	1	5	2
B	2	4	8

For your reference I'm attaching sample file please check it.

Hope it helps you.

Cheers!!

Jagan Nalla

Re: Dynamic columns in table.

Fri, 09 Nov 2012 10:19:01 GMT

Great answer!!!

The original post is not mine i can't vote, but this is 10 point answer!!!

thanks

Wava

Re: Dynamic columns in table.

Anonymous — Fri, 09 Nov 2012 22:15:18 GMT

Tell me what mistakes do i made while replicating properties of your component to get "the same" result? At this point I get aggregated ( icon with plus ) results and no answer from value property..

Re: Dynamic columns in table.

whiteline — Sat, 10 Nov 2012 08:23:55 GMT

Expand to see the years. Click on the year header and drug it. You should see a blue arrow.

Move it to the right top so that it become horizontal. Release.

Re: Dynamic columns in table.

Anonymous — Wed, 14 Nov 2012 21:27:38 GMT

It is close, but using column as row is possible only in "pivot chart", but what If I have

2000 2001 2002

A C 1 2 3

B D 5 6 7

I'll get just :

A [+], C

B [+]. <nothing>

Is there any way to get rid of that aggergation or I'll have to do it by my self with some js script and

external component ? Maybe there is other way to join table and pivot table components together, but

there might be problems with grater number of rows then it's possible to display on screen.

Re: Dynamic columns in table.

MayilVahanan — Wed, 14 Nov 2012 21:31:42 GMT

Can you please upload sample file? Will check n give the solution. Its helps us to solve your requirement.

Re: Dynamic columns in table.

Anonymous — Wed, 14 Nov 2012 21:42:06 GMT

Uploaded, as You can see [+]'s causes problems.

Re: Dynamic columns in table.

Anonymous — Wed, 14 Nov 2012 21:48:04 GMT

Found it "Always fully expanded" in presentation tab.

Re: Dynamic columns in table.

MayilVahanan — Wed, 14 Nov 2012 21:53:17 GMT

Name2 : A, Name3:C has value2 for year 2000 only. so for remaining its display null value.Same way for remaining case.

So in this case, you can use ordinary straight or pivot table..

PFA