Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display Min and Max

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

3 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi,

Please check the attachment for solution.

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

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
Partner - Champion III
Partner - Champion III

Hi,

Any luck.

Regards,

Jagan.