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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Min and Max Values

Hello All,

                   I had a list box and i created A anb B fields.I will show you the code for your better understanding

T1:

LOAD * INLINE [

    A, B

    4, 8

    5, 11

    69, 31

    200, 91

    1, 7

    10 , 5

];

STORE  T1 into T1.qvd;

INPUTFIELD A,B;

T1:

LOAD A,

     B

FROM

T1.qvd

(qvd);

A:

LOAD 'A' as F,

Max(A) as MaxA,

Min(A) as MinA

Resident T1;

//DROP Table T1;

B:

LOAD 'B' as F,

Max(B) as MaxA,

Min(B) as MinA

Resident T1;

DROP Table T1;

Now i need to create a variable.For example say variable name as vAMin.Now if i click on A the value should directly go and store into vAMin variable same for Max also.

Can anyone please help me how to do it.

Regards,

R.Bharat Kishore

20 Replies
Jason_Michaelides
Partner - Master II
Partner - Master II

Just search/post any new queries to the forum and get the benefit of everyone's expertise!

Glad we got it sorted for you.