topic Re: Display Min and Max in QlikView

Display Min and Max

Tue, 07 Feb 2012 09:15:16 GMT

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,

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).

Re: Display Min and Max

jagan — Tue, 07 Feb 2012 10:09:24 GMT

Hi,

Please check the attachment for solution.

Hope this helps you.

Regards,

Jagan.

Display Min and Max

Tue, 07 Feb 2012 10:36:40 GMT

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.

Display Min and Max

jagan — Tue, 07 Feb 2012 13:43:13 GMT

Hi,

Any luck.

Regards,

Jagan.