topic Re: find out current period in QlikView

find out current period

hopkinsc — Thu, 30 May 2013 10:57:44 GMT

i have a field ' Reporting Period'

how would i find out todays reporting period?

thanks

hopkinsc — Thu, 30 May 2013 11:16:01 GMT

hi, sorry, in my calendar i have dates, periods, quarters etc

I don't want to work the period out as the periods are already in my data.

so todays date =

30/05/13 and the period is 5

So i want to display (in a text box) the current period (without making any date selections)

my fields are :

Reporting Date

Reporting Period.

Does that make sense?

Thanks

hopkinsc — Thu, 30 May 2013 11:38:56 GMT

hi, no sorry, that didnt work

hopkinsc — Thu, 30 May 2013 11:47:16 GMT

i have attached a sample.

I want to display the reporting period in the text box without making any selections.

Thanks

hopkinsc — Thu, 30 May 2013 15:21:52 GMT

does anyone have any ideas please?

Thu, 30 May 2013 17:01:31 GMT

Hi,

you are searching for something like this:

=only( {< [Reporting Date] = {"$(=today())"} >} [Reporting Period] )

It works, have fun.

Best

Sacho Alexander Josachkoff

hopkinsc — Fri, 31 May 2013 07:41:44 GMT

Thanks very much, that's exactly what i was looking for