topic Re: between data? in QlikView

between data?

Anonymous — Thu, 08 Jan 2015 07:23:23 GMT

Hi i have fields called

date,date2

date:

1/1/2014

2/1/2014

3/1/2014

4/1/2014

5/1/2014

6/1/2014

7/1/2014

8/1/2014

9/1/2014

10/1/2014

11/1/2014

date2 is like calendar object when i enter date2 =3 and selected date is 5/1/2014

i want see result for

4/1/2014,

3/1/2014,

2/1/2014,

pls give me expr for this ?

sushil353 — Thu, 08 Jan 2015 07:31:44 GMT

hi,

the expression could be:

sum({<Date={">= $(=Date(Max(Date)-3)) <$(=Max(Date))"}>}sales)

HTH

Sushil

Anonymous — Thu, 08 Jan 2015 07:34:51 GMT

its for static if date2 may change like 1 ,5 ,7 ....

what i have to put instead of 3 for dynamic

Anonymous — Thu, 08 Jan 2015 07:36:22 GMT

and eventhough u r telling max(date) but i dont want select max(date) always

in between if i select any date it should work for that date

as per ur exp its always take max(date)

sushil353 — Thu, 08 Jan 2015 07:40:52 GMT

Hi,

If you are assigning date2 in some input box then that variable you can use in your expression in place of 3

sum({<Date={">= $(=Date(Max(Date)-vDate2)) <$(=Max(Date))"}>}sales)

and Max(Date) will get the max date of your selection..

HTH

Sushil