topic Re: Age range variables in QlikView

Age range variables

Wed, 30 Apr 2014 08:48:41 GMT

Hi All,

I need to make a 2 input fields with variables, one "Age from" and second "Age till". This will be Age range. And for exapmple, when i in the firs field i enter 20, in second 35, it must retur

only customers ho have age between 20-35. Please help.

my expresion is: =count({$<LastMembershipDueDate={ "<$(=Date(Today(), 'YYYY.MM.DD'))" },OfferingCategory1={'Narystės'} >}distinct CustomerID )

Re: Age range variables

MK_QSL — Wed, 30 Apr 2014 08:52:30 GMT

Can you post sample data or sample apps?

Re: Re: Age range variables

Wed, 30 Apr 2014 08:57:56 GMT

count({$<LastMembershipDueDate={ "<$(=Date(Today(), 'YYYY.MM.DD'))" },OfferingCategory1={'Narystės'}, Costumer.Age = {>=$(minAge)<=$(maxAge)} >}distinct CustomerID )

hope this helps!

regards,

Re: Re: Age range variables

Wed, 30 Apr 2014 08:58:45 GMT

minAge and maxAge would be the name of your variables

Re: Age range variables

MK_QSL — Wed, 30 Apr 2014 08:59:39 GMT

What is the definition of Min and Max Age?

Re: Age range variables

christian77 — Wed, 30 Apr 2014 09:03:08 GMT

Here are 2 ways of doing it

Re: Age range variables

Wed, 30 Apr 2014 09:08:28 GMT

like she posted at the beginning she has to input fields where she types in the min and max age! and and inputfield usually needs a variable to save the input value.

Re: Age range variables

Wed, 30 Apr 2014 10:05:34 GMT

Thanks all of you, i little modified Magdalens set analysis and it works

count({$<LastMembershipDueDate={ "<$(=Date(Today(), 'YYYY.MM.DD'))" },OfferingCategory1={'Narystės'}, Customer.Age = {'>=$(minAge)<=$(maxAge)'} >}distinct CustomerID