topic Re: Display Values in QlikView

Display Values

bharatkishore — Thu, 02 Feb 2012 12:43:41 GMT

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

Display Values

CELAMBARASAN — Thu, 02 Feb 2012 13:22:54 GMT

Hi,

You created list box based on calculated expression?

Celambarasan

Re: Display Values

bharatkishore — Thu, 02 Feb 2012 13:29:57 GMT

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

Display Values

CELAMBARASAN — Thu, 02 Feb 2012 14:04:26 GMT

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

Re: Display Values

bharatkishore — Thu, 02 Feb 2012 14:20:45 GMT

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,

FROM

T1.qvd

(qvd);

LOAD 'A' as F,

Max(A) as MaxA,

Min(A) as MinA

Resident T1;

//DROP Table T1;

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

Display Values

CELAMBARASAN — Thu, 02 Feb 2012 15:04:51 GMT

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

Re: Display Values

bharatkishore — Thu, 02 Feb 2012 15:07:38 GMT

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