topic Re: Limit dimension values in list box in QlikView

Limit dimension values in list box

Mon, 16 Jun 2014 11:34:48 GMT

Hi,

I want a listbox in my QV Model however I only want the selection for those employees that have created a new product in the last 90 days not everybody.

I don't know if I'm on the right line below - as yet it doesn't appear to work.

=if(count({$<CreationDate ={">$(v90days)"}>} CreationDate)<>0, EmployeeName, null())

Many thanks

Re: Limit dimension values in list box

Mon, 16 Jun 2014 11:44:05 GMT

Hi Chirag

i guess $(v90Days) id a date like today()-90

Date format can be different between CreationDate and $(v90Days). It then gives no result

second is {$<CreationDate =....

$ means set analysis will be based on the current selection. It might be what you want. If you want to check on the whole set of data reaplce it by 1

best regards

Chris

Re: Limit dimension values in list box

sasikanth — Mon, 16 Jun 2014 12:04:50 GMT

can you let me know what you are using in v90days variable

Re: Limit dimension values in list box

Mon, 16 Jun 2014 12:25:20 GMT

HI Chirag

create a variable to hold the date for v90days: =date(floor(today()-90))

then in the list box that holds the employee name write the below as an expression in the field under the tab General

=if(created ate>=v90days,employeename)

thanks and regards

padma

Re: Limit dimension values in list box

Mon, 16 Jun 2014 12:33:15 GMT

Hi Chirag, Please use the below expression:

IF(CreationDate >= Floor(today() - 90) , EmployeeName)

It will work eventhough your CreationDate is any format it will work.

If you have more data, then Create the Flag in the Script level and use the Flag in the List box expression.

Script:

LOAD *,

IF(CreationDate >= Floor(Today()-90) , 1,0) AS 90DAYFLAG

From EmplyeeDetail.qvd (qvd) ;

LB Expression:

IF(90DAYFLAG, EmployeeName)

Re: Limit dimension values in list box

Tue, 17 Jun 2014 08:22:57 GMT

Thanks for that; funnily enough after taking a step back and simplifying what I was doing I came up with the same solution - =IF(CreationDate >= v90days, EmployeeName, NULL()). Is there any benefit using the NULL()?

I'm actually going to make the variable dynamic in that the user will be able to set it to 30 days, 60 days or 90 days using a slider.

Thanks for your help again.