topic Formula for date begin selected year in QlikView

Formula for date begin selected year

Tue, 12 Aug 2014 08:44:03 GMT

Hi,

I'm looking for the formula in the expressions for the first day of the selected year.

So if I select 2014 i wanne have 01-01-2014

If I select 2013 i wanne have 01-01-2013.

Can somebody help me?

Anonymous — Tue, 12 Aug 2014 08:45:20 GMT

Try the YearStart function

Tue, 12 Aug 2014 08:48:31 GMT

I have this formula at the moment: date(YearStart( Today()))

But that one gives me 01-01-2014 while I selected 2013

ashfaq_haseeb — Tue, 12 Aug 2014 08:48:50 GMT

Hi,

Try below

=YearStart(Your Date)

Regards

ASHFAQ

ashfaq_haseeb — Tue, 12 Aug 2014 08:50:00 GMT

Hi,

Replace today() with your datefield.

Regards

ASHFAQ

Anonymous — Tue, 12 Aug 2014 08:51:04 GMT

Today() returns today's date.

You need to use whatever field you are doing the selection on.

Tue, 12 Aug 2014 09:18:34 GMT

Thank you very much for your help. Doesn't work yet but I understand why it doesn't work. Trying to get the right date field instead of Today().