topic Re: Hello , in QlikView

Hello ,

Thu, 18 Jun 2015 12:41:40 GMT

can anyone help me generate a formula to display data from the beginning of the year to the current selection( NOT CURRENT DATE).

ex: input data

jan- 2

feb-3

march-5

so if we select, the output should be:

jan=2

feb=5

march=10

Re: Hello ,

Thu, 18 Jun 2015 12:56:56 GMT

Try this,

set a variable like vyear = '>=' & Date(YearStart(Today())) & '<=' & Date(Today())

and in your expression, give like SUM({<Month=, Date={"$(vyear )"}>} output field name)

Make sure you have proper calendar with year, month, date...

HTH

Re: Hello ,

Anonymous — Thu, 18 Jun 2015 20:47:34 GMT

if([DateField]>=date(yearstart(today())) and [DateField]<getselected([DateField]),[DataField],Null())

I haven't tested this but that is the logic I would start with.

Re: Hello ,

Fri, 19 Jun 2015 09:38:55 GMT

Hello Thanks for your response; but i think your solution will give till the current date; but is actuallly expected is:

if the Month: "Feb " is selected now, data should get populated only TILL FEB data ie(though we are in June, if i select FEB, data should be from Jan 1st to Feb 28th)

Re: Hello ,

Fri, 19 Jun 2015 09:42:40 GMT

the above solution will work as per your selection only.

if you select feb, it will give data from year start till feb.

have you tried the above expression??