topic Min and Max Values in QlikView

Min and Max Values

bharatkishore — Tue, 07 Feb 2012 10:13:06 GMT

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,

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

Min and Max Values

CELAMBARASAN — Tue, 07 Feb 2012 10:21:16 GMT

Hi,

Check the trigger option in Document Properties --> Trigger tab

under that you will have field event triggers.

select the field and add action for the on select trigger event from that use set variable option.

Hope it helps

Celambarasan

Min and Max Values

bharatkishore — Tue, 07 Feb 2012 10:27:34 GMT

HI Celambarasan,

Thanks a lot for your reply if possible can you please explain more clearly if possible please send me step wise because i am new to qlikview.

Please don't mind because i am new to qlik view.

Regards,

R.Bharat Kishore

Re: Min and Max Values

Jason_Michaelides — Tue, 07 Feb 2012 10:30:49 GMT

If I understand your requirement correctly you don't need to load the Min and Max in the script. Just load your inline table, then in the UI create a variable vMin_A and set the expression to =Min(A). Create vMax_A=Max(A).

You variable will always be the min/max of field A, based on current selections. If you want to exclude current selections use Set Analysis and set vMin_A to be =Min({1} A)

Hope this helps,

Jason

Min and Max Values

CELAMBARASAN — Tue, 07 Feb 2012 10:42:21 GMT

Hi,

Settings-->Document Properties or (Ctrl+Alt+D)

Go to the trigger tab in that dialog.

Select the Field name under the Field Event trigger lists.

Click the add action button for the on select.

In that Add-->External-->Set variable-->use variable name and the value to set

Min and Max Values

bharatkishore — Tue, 07 Feb 2012 11:09:14 GMT

Thanks a lot.I have one more question if i click on A it is dispaying variables for Min and Max of A.Now as well as if i click B it should also display for that.

Can you please tell me how to do it.

Regards,

R.Bharat Kishore.

Min and Max Values

Jason_Michaelides — Tue, 07 Feb 2012 11:12:29 GMT

I don't follow. Just create two more variables - vMin_B and vMax_B...

Re: Min and Max Values

bharatkishore — Tue, 07 Feb 2012 11:15:59 GMT

Thanks a lot Jason for your reply.I created two more variables.But Its not working.Total four variables are there.But if i click on A it is displaying on all four text objects.But if i click on A it should display on A only.And when i click A and B it should display A values on A and B values On B.

Can you please help me how to do?

Min and Max Values

Jason_Michaelides — Tue, 07 Feb 2012 11:21:28 GMT

vMin_B:

If you want it based on curent selections (bear in mind your selections of field A may well impact this):

=Min(B)

If you want current selections excluded then:

=Min({1} B)

vMax_B:

If you want it based on curent selections (bear in mind your selections of field A may well impact this):

=Max(B)

If you want current selections excluded then:

=Max({1} B)

Hope this helps,

Jason

Re: Min and Max Values

bharatkishore — Tue, 07 Feb 2012 12:05:04 GMT

Thanks a lot Jason For your Reply.Assume that I took 4 text objects and in the first text object i gave conditon as =vAMin to dispaly Min value of A and for Max i gave condition in second text object as =vAMax.

Same for the remaining text objects i mean i created two more variables for B also as vBMax and vBmin.But if i click on A it is displaying same values for all four objects.Please Help me.

Regards,

R.Bharat Kishore

Re: Min and Max Values

Jason_Michaelides — Tue, 07 Feb 2012 12:05:51 GMT

Please post your app.

Re: Min and Max Values

bharatkishore — Tue, 07 Feb 2012 12:10:43 GMT

I attached Please Check

Re: Min and Max Values

Jason_Michaelides — Tue, 07 Feb 2012 12:38:07 GMT

Remember I said you don't need to define the Min and Max in the script.

See attached. Hope this helps,

Jason

Re: Min and Max Values

bharatkishore — Tue, 07 Feb 2012 13:22:00 GMT

Jason actually my requirement is different.It is when we click on A it should display the min and max value of A in the text object.

And same for B also.Please don't mind.If possible please help me and i am so thankul to you because you are giving your precious time for me.

Regards,

R.Bharat Kishore

Re: Min and Max Values

Jason_Michaelides — Tue, 07 Feb 2012 14:05:57 GMT

Maybe use a data island. See attached.

Re: Min and Max Values

bharatkishore — Tue, 07 Feb 2012 14:22:32 GMT

Jason But in that List Box the Min and Max values Also should display.Then my proble is solved.Everything is correct except that Min and Max values in that Listbox.

Please help me.

Regards,

R.Bharat Kishore

Re: Min and Max Values

Jason_Michaelides — Tue, 07 Feb 2012 14:56:32 GMT

Right. I think I finally understand your requirements....!

You're data model is wrong and not expandable. I've assumed that your inline table is just an example and actually you will load much more data from a database or flat file. You data may have more than just A and B also - maybe A,B,C,D,E and F. So I've "crosstabled" the data in the script and used listbox expressions to control the display - you do not need to use any variables.

However, this solution means that your selection in the listbox affects the rest of the data...

Hope this helps,

Jason

Re: Min and Max Values

Jason_Michaelides — Tue, 07 Feb 2012 15:17:32 GMT

With option to not affect the rest of the data...

Re: Min and Max Values

bharatkishore — Wed, 08 Feb 2012 08:18:11 GMT

Jason sorry for asking you these many times actually in our list box we need to display min and max values before clicking and also after we click then it should display in text objets.

I am attaching my file again please have a look.

Regards,

R.Bharat Kishore

Re: Min and Max Values

Jason_Michaelides — Wed, 08 Feb 2012 10:35:34 GMT

Here you go then. Of course this means you have to create your text boxes in advance for each different Fiald value (A,B,C etc) - it won't expand automatically.

Jason