Display Min and Max

[#1]

Hello,

I've different number of fields in my qvd. So i want to see min & max of each field side by side.

For eg:

Table1:

Load

LKey,

A,

B,

C

from Table;

In front end i want to see in table box in below format.

Is it possible in qlikview?

ALLFields      Min        Max

A                    21           38

B                    56         489

C                    10         100

And also if is select particular LKey the min and max should change with respective of my selection( i.e. it should have link).

[jagan]

Hi,

Please check the attachment for solution.

Hope this helps you.

Regards,

Jagan.

[#3]

Jagan,

It is good idea, But can you help me little bit more.

I've different number of fileds in my qvd file. for example i've  Load    A,B,C,D,E,F,G,H,I,J,K..........Z from table;

Now i want to make a group and display A,B,C,........W in on table box X,Y,Z in another listbox along with there min and max values.

So according to your code i need to write different number of IF conditions in the expression part. It gives burden to chart to display data based on condition for large amount of data. Is there any other way to achive this. Meanwhile i'll integrate with you logic.

[jagan]

Hi,

Any luck.

Regards,

Jagan.