How can we make summarized data?

Sat, 12 Nov 2011 14:54:30 GMT

I've table data in the below format.

Lkey DefectName LensResult A B X Y

101 EdgeChip Fail 4 8 1 2

101 EdgeChip Fail 2 5 3 6

101 EdgeTear Fail 3 1 5 7

Now i need to show the result as below

Lkey MInA MaxA MinB MaxB

101 2 4 1 8

One way:

To achive this i have take straight table and dimension as Lkey and expression as Min(A),Max(A),Min(B),Max(B). Now the result is as i want i can see. But the problem is when i add X, Y in dimension it shows different data. I want to know is this is the way to summarize the data. I want to summarize all the fileds except what the fields which we are using for Min,Max calculation.

SecondWay:

Load Lkey,

DefectName,

LensResult,

Min(A),

Max(A),

Min(B),

Max(B)

from table1.qvd

Group By

Load Lkey,

DefectName,

LensResult ;

- But it is consuming lot of time to load above table in my application b'coz i've more than 100 fields with large amount of data to summarize. Just i've shown u with few fileds only.

Which is the best way to achive the summarize data or is there any way to achive this.

Can anyone please help me on this.

For your reference i'm attaching my file

How can we make summarized data?

swuehl — Sat, 12 Nov 2011 15:06:36 GMT

Hi jacq,

I believe that again, the TOTAL qualifier within the aggregation functions is your friend:

Try using

Min(total<Lkey> A), Max(total<Lkey> A) etc.

to get the results like above even when you are adding more dimensions (these will be disregarded by the TOTAL).

You can add more dimensions to the total after Lkey if you need to regard any more.

Hope this helps,

Stefan

How can we make summarized data?

Sat, 12 Nov 2011 16:21:22 GMT

Tnx a lot swuehl once again.

topic How can we make summarized data? in QlikView

How can we make summarized data?

How can we make summarized data?

How can we make summarized data?