topic Values that lies between two variables in QlikView

Values that lies between two variables

Wed, 20 Nov 2013 15:12:22 GMT

Hi,

Can you please help me to resolve this issue :

I have to list the years between a selected year Y and Y-1.

For example:

My selected Year is : 2013

The number of years on the past is : V_YearBack = 3

So i have to get : 2013 2012 2011 2010

Can any one help me ?

Thanks

Re: Values that lies between two variables

Clever_Anjos — Wed, 20 Nov 2013 15:17:15 GMT

Something like

sum({<Year ={">=$(=MAX(Year)-$(V_YearBack ))"}*{"<=$(=MAX(Year))"}>} yourfield)

should solve your need

Re: Values that lies between two variables

Wed, 20 Nov 2013 15:34:37 GMT

Hi,

Thanks for your response but this doesn't resolve my problem.

I put : =sum({<Year ={">=$(=MAX(Year)-$(V_YearBack ))"}*{"<=$(=MAX(Year))"}>} Year)

and i got : Error on Dimension

Any other suggestion ?

Re: Values that lies between two variables

Josh_Good — Wed, 20 Nov 2013 15:48:14 GMT

I have a few thoughts on how this could be done but it would depend on where you want the list to appear. Could you please post a sample QVW showing where you need the list to appear.

Re: Values that lies between two variables

Wed, 20 Nov 2013 15:52:16 GMT

Hi ,

Please use the code as below

=Sum({$<Year ={">=$(=(max(Year ))-$(V_YearBack)-1) <=(max(Year ))"}>} FieldName)

Regards

Yusuf

Re: Re: Values that lies between two variables

Wed, 20 Nov 2013 16:03:27 GMT

Hi,

Please find attached my example.

What i want is : when i select for example 2013 and YearBach=3, i have to get on the table those years : 2013, 2012,2011

Can you help please ?

Re: Re: Values that lies between two variables

Wed, 20 Nov 2013 16:03:49 GMT

Still the same error message

Re: Re: Re: Values that lies between two variables

Wed, 20 Nov 2013 16:26:42 GMT

Hi ,

can you please try now .

=Sum({$<Year ={">=$(=(max(Year ))-$(V_YearBack)) <=$(=(max(Year) ))"}>} Sales)

Also please find the attachment .

Regards

Yusuf

Re: Values that lies between two variables

Thu, 21 Nov 2013 09:51:13 GMT

Hi Yusuf,

I tested the solution that you sent me and i think this will resolve a part of my problem

Thank you so much for your help ... i will add this part of development on my application and i will let you know if it is ok.

Thanks

Re: Re: Re: Values that lies between two variables

Wed, 04 Dec 2013 15:52:39 GMT

Many Thinks it works

Re: Re: Re: Values that lies between two variables

Wed, 04 Dec 2013 16:00:51 GMT

Hi Experts ,

I have now another question about this topic,

I am now trying to do this Aggr with the recommanded solution :

=Max(Aggr(Sum({$<Year ={">=$(=(max(Year ))-$(V_YearBack)) <=$(=(max(Year) ))"}>} Sales_EUR),Week_Extract))/1000

But this ... doesn't work !!

Any help is welcome

Thanks

Re: Re: Re: Re: Values that lies between two variables

matthias_v — Wed, 04 Dec 2013 17:00:47 GMT

Hi,

See the attachment. I think this might be what you are looking for

Re: Values that lies between two variables

Fri, 06 Dec 2013 10:55:49 GMT

Yessssss .... It Works

Thanks a lot