Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Display Values

Hello ALL,

                      I have A list box.In that i have check box and values as  A 200  1

                                                                                                       B 91     5.

When I am clicking on Check Box A. B Values r not appearing.U can See in below.

A 200 1

-  -      -

But I want to see B values also.Can anyone Pls Say to me how to do.

Regards,

R.Bharat Kishore

6 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You created list box based on calculated expression?

Celambarasan

bharatkishore
Creator III
Creator III
Author

I attached My Qlikview File.Please Check it and please help me.

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Sorry i'm using personal edition. Can you tell me ur problem in picture? and what expression you have used in it?

Regards

Celambarasan

bharatkishore
Creator III
Creator III
Author

NO problem.I am Taking Max And Min values For A and B.I will in given Below

//T1:

//LOAD * INLINE [

//   

//  

//    A, B

//    51, 8

//    29,11

//    69, 31

//    200, 91

//    1, 7

//    10 , 5

//];

//STORE  T1 into T1.qvd;

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 took expression is MAX(A) and MIN(A) To display the MAX and Min Values.

Regards,

R.Bharat Kishore

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     You mean you displayed F in separate list box, MaxA in separate list box and MaxB in separate list box ?

     If not so then you used MaxA and MaxB as expression in list box in this case use

          Only({1} MaxA)

               and

          Only({1} MaxB)

Hope this helps.

Celambarasan

bharatkishore
Creator III
Creator III
Author

Thanks  A lot For your Reply and i want to edit the values in list box.Can you tell me how to do.I mean i will get 200 as Max VAlue.

         But i want to edit the 200 value and iwant to keep some other value can u pls tell me how todo?

Regards,

R.Bharat Kishore