topic Re: exclude selections apart from 1 field in QlikView

exclude selections apart from 1 field

Wed, 27 Mar 2013 19:50:50 GMT

Hi,

can anyone tell me how to exclude current selections apart from 1 field.

I have the following expression..

=max({1}[EventDate])

That excludes all current selections, but how do i tell it to allow selections made on the EmpID field?

Thanks

Re: exclude selections apart from 1 field

Wed, 27 Mar 2013 20:14:08 GMT

any ideas anyone?

Re: exclude selections apart from 1 field

vivientexier — Wed, 27 Mar 2013 20:19:31 GMT

Try this :

Create a variable as follow :

=Concat(EmpID, ', ') (don't forget the "=" sign)

Then, your expression :

Max({1 < EmpID={$(=vYourVariable)} >} [EventDate])

Re: exclude selections apart from 1 field

Wed, 27 Mar 2013 20:36:00 GMT

hi, thanks for your reply..

i have tried this in a text box

=Max({1< [EventDate]={$(=vtest)}>} [EventDate])

but i get no result.

The above are my actual field names.

the variable vtest shows me the correct dates so i know this part works.

Re: exclude selections apart from 1 field

vivientexier — Wed, 27 Mar 2013 20:42:55 GMT

You mean :

=Max({1< EmpID={$(=vtest)}>} [EventDate])

Re: exclude selections apart from 1 field

Wed, 27 Mar 2013 20:46:07 GMT

no, sorry, i mean i know the vtest variable displays the dates. it just doesnt work when i add the variable to the expression you gave... =Max({1< [EventDate]={$(=vtest)}>} [EventDate]).

Is it to do with the field being a date field?

Re: exclude selections apart from 1 field

Wed, 27 Mar 2013 20:46:43 GMT

no, the empid was an example..

Re: exclude selections apart from 1 field

Wed, 27 Mar 2013 20:48:35 GMT

i want to have a variable for the min and max [eventdate] but the user can change the [eventdate] range and the min and max needs to change with the new date selection.

Re: exclude selections apart from 1 field

vivientexier — Wed, 27 Mar 2013 20:55:16 GMT

The problem can be a format problem.

Convert your date to a numeric into your script, then, retry.

Re: exclude selections apart from 1 field

srinivasa1 — Wed, 27 Mar 2013 20:57:36 GMT

Upload your sample app

Re: exclude selections apart from 1 field

vivientexier — Wed, 27 Mar 2013 21:02:32 GMT

Sum({< EventDate_num={">=$(=Min(EventDate_num)) <=$(=Max(EventDate_num))"}, EventDate_num= >} KPI)