topic Re: Can't input the same numbers range in two Min Max variables in QlikView

Can't input the same numbers range in two Min Max variables

jasonseril — Mon, 16 Feb 2015 01:38:35 GMT

Hello All,

My requirement is to input a range of values to a four (4) input boxes, currently Im using four variables to get the two minimum and maximum values, the requirement is after inputting the first min-max values, user should not be able to input again the same values in the second min-max.

EX:

Min: Max:

Group 1 : ABC 10 15

in Group 2's Min and Max, user can only input 1 and 9 or 16 to any numbers.

Any set analysis suggestions to this requirements? Please help.

Thanks and more power!

Best regards,

Jason

Re: Can't input the same numbers range in two Min Max variables

AbhijitBansode — Mon, 16 Feb 2015 06:46:55 GMT

Hi,

PFA.

Hope it serves your purpose.

Re: Can't input the same numbers range in two Min Max variables

jasonseril — Mon, 16 Feb 2015 07:05:00 GMT

thank so much, Abhijit.

Re: Can't input the same numbers range in two Min Max variables

jasonseril — Mon, 16 Feb 2015 09:54:45 GMT

by the way cabhijit what about user inputs this values:

Min Max

Group 1: ABC 10 - 15

however in

Min Max

Group 2: DEF any of 1 to 8 - 9 only

or 16 - any number higher than 16

Thanks.

Re: Can't input the same numbers range in two Min Max variables

AbhijitBansode — Mon, 16 Feb 2015 10:03:41 GMT

Hi Jason,

If your input for Group1 is ,Min -10 Max -15

Then constraints on input boxes of Group2 will take care of only allowing Min numbers in the range of 1to 9 and Max number >15 only.

Below are the constraints on Group2 input box:

Group2Min:

$ >= 0 and $<$(vGrp1Min)

Group2Max:

$>$(vGrp1Max)

Re: Can't input the same numbers range in two Min Max variables

jasonseril — Mon, 16 Feb 2015 10:18:53 GMT

Hi Abhijit,

I understand. Let me explain the requirements, in Group1 the user inputs min=10 and max=15 so the range values for group1 is (10, 11, 12, 14, 15), Now for Group2, user may input min=1 to 8 and max=9 only, the range values for Group2 (1,2,3....9) or user may input min=16 to any number and max=17 to any number, now the range values for Group2 would be (16,17...).

i wonder if this is possible.

thanks again, Abhijit cabhijit

Re: Can't input the same numbers range in two Min Max variables

AbhijitBansode — Mon, 16 Feb 2015 11:08:10 GMT

If I understood your problem correctly,

does this attached suffice your requirement?

Re: Can't input the same numbers range in two Min Max variables

jasonseril — Mon, 16 Feb 2015 23:09:18 GMT

yes Abhijit, all thumbs up. thank you so much.

Br,

Jason