topic Using a List Box Selection is an Expression in QlikView

Using a List Box Selection is an Expression

Thu, 26 May 2011 16:00:34 GMT

I am trying to have a list box select (percent probability to close) and would like to have the below formula reference a selected range rather than it being hard coded.

sum({ $<Forecast_CloseDate={'05-2011'}, Forecast_Probability ={'>70<100'}>} ForecastOppAmount)

Any and all ideas would be helpful

Thanx

Using a List Box Selection is an Expression

brenner_martina — Thu, 26 May 2011 16:29:33 GMT

Hi,

where do you use this expression? Is Forecast_CloseDate really a string? otherwise you have to use a number like: Num(Monthname(Datefield)) As Num_Forecast_CloseDate

and the expression p.e.:

Let variable = Num(Makedate(2011,5,1));

sum({ $<Num_Forecast_CloseDate={$(variable)}, Forecast_Probability ={'>70<100'}>} ForecastOppAmount)

Using a List Box Selection is an Expression

Thu, 26 May 2011 16:32:45 GMT

Hi Martina,

Forecast_Claose Date is a date field. What I would like to relace is the Forecast_Probability with a manually selectable something(inputbox, list box etc) but cant figure out how to make the probability dynamic

Using a List Box Selection is an Expression

brenner_martina — Thu, 26 May 2011 16:57:34 GMT

Hi, Allen,

I do not yet understand, what do you want. If you want to get a listbox to select some values calculated by conditions it is better to do this in the script, something like:

Load ...,

if(MonthName(Forecast_CloseDate)=Monthname(Makedate(2011,5,1) And

Forecast_Probability>=70 And Forecast_Probability<=100,'Select','Unselect') As Fieldname,

...

From ...;

Than you have Fieldname for using a listbox.

Greetings from Munich

Using a List Box Selection is an Expression

Thu, 26 May 2011 17:01:52 GMT

The formla works perfectly....what I would like, is for my end user to be able to alter the probability percent range. Currently, the probability is hard coded into the expression which the end user cant change. So basically, I would liek to create a variable that I could use in the expression in place of teh probability, where the user can select their deaired range.

Sorry if this is unclear....as you can see Im struggling as well.

sum({ $<Forecast_CloseDate={'05-2011'}, Forecast_Probability ={'>70<100'}>} ForecastOppAmount)

Using a List Box Selection is an Expression

brenner_martina — Thu, 26 May 2011 17:04:12 GMT

Hi, Allen,

use variables for the margins and a Slider with two variables

Var1: 70

Var2: 100

Using a List Box Selection is an Expression

Thu, 26 May 2011 17:14:13 GMT

Martina,

I like the solution, but for the life of me I cannot get the slider to produce two variables a max and min....am I doing something wrong?

I tried the slider relating to variables and directly to the field...nothing works

Using a List Box Selection is an Expression

Thu, 26 May 2011 17:18:35 GMT

Actually, is there a way through input boxes where the enduser can control the probability range? and if so how is the expression written?

Using a List Box Selection is an Expression

Thu, 26 May 2011 17:29:27 GMT

Or...is there a way to formulariclly write an expression to reference selection from a list box?

Using a List Box Selection is an Expression

brenner_martina — Fri, 27 May 2011 08:59:38 GMT

Hi, Allen,

can you send me an example?

Re: Using a List Box Selection is an Expression

Anonymous — Thu, 11 May 2017 16:53:58 GMT

Use 2 variables with Input Boxes.

Create new object > Input Box

Click new variable and name the variable ie. vRangeStart

Click new variable again and name it ie vRangeEnd

(Use label box to 'rename' the variable in the UI.

Users can then enter values free form.

Refer to variables in expression using set analysis.

Something like

sum({ $<Forecast_CloseDate={'05-2011'}, Forecast_Probability ={'>=$(vRangeStart)<=$(vRangeEnd)'}>} ForecastOppAmount)