topic Re: Need Expression in QlikView

Need Expression

saumyashah90 — Wed, 16 Oct 2013 06:57:43 GMT

I Have

Load * Inline [

A,B,C,D

1,2,3,4

5,6,7,8

9,10,11,12

6,4,3,2

];

i Want Output as

A B C D
Sum 21 22 23 26

Count 4 4 4 4

Re: Need Expression

saumyashah90 — Wed, 16 Oct 2013 07:15:35 GMT

any one?

Re: Re: Need Expression

tresB — Wed, 16 Oct 2013 07:17:25 GMT

PFA.

Easier way should be there, you might have to transform the table in the script.

Update: the Saumya_tes one is more dynamic !

Re: Need Expression

senpradip007 — Wed, 16 Oct 2013 07:18:58 GMT

Do you want the output in script or in UI ?

Re: Need Expression

saumyashah90 — Wed, 16 Oct 2013 07:24:55 GMT

Hey tresesco

That was nice but still,

For now i have only A,B,C,D in real i have 1000's of fields
i want it kind of dynamic.

Re: Need Expression

saumyashah90 — Wed, 16 Oct 2013 07:25:36 GMT

any where in UI or Script,

Please consider that i have 1000's of similar fields like A,B,C,D

Re: Re: Need Expression

tresB — Wed, 16 Oct 2013 07:26:46 GMT

Check my second attachment please.

Re: Re: Need Expression

senpradip007 — Wed, 16 Oct 2013 07:27:15 GMT

PFA

Re: Need Expression

saumyashah90 — Wed, 16 Oct 2013 07:32:42 GMT

Hi Tresesco,

That was correct. Can you explain the use of

CrossTable
Load '1' as Dummy,*;

//What does this do?

Load * Inline [

];

Re: Re: Need Expression

tresB — Wed, 16 Oct 2013 07:38:44 GMT

it transform the table. A, B, C, ... values are taken into a field and the corresponding values in another field. 'Dummy' field is created and dropped for the proper formatting of table(by default crosstable() takes the first field as it is, and i needed to change the first field). Hope this gives you an idea. for better understanding learn CROSSTABLE a very useful function.