topic Re: Current Period in QlikView

Current Period

Thu, 16 Oct 2014 12:37:54 GMT

I have a field named fiscalNumber having 1-13 periods.

But i want the current period means period of today().

I want something like this

Max({<Calendar_Date={'16/10/2014'}>} FiscalPeriodNumber)

Please help. Its urgent.

Thanks !!!!!!

Re: Current Period

MK_QSL — Thu, 16 Oct 2014 12:43:04 GMT

Only({<Calendar_Date={'$(=Today())'}>} FiscalPeriodNumber)

Re: Current Period

Thu, 16 Oct 2014 12:47:15 GMT

it returning null value.

Re: Current Period

MK_QSL — Thu, 16 Oct 2014 12:50:22 GMT

Provide sample data please..

Re: Current Period

Thu, 16 Oct 2014 12:51:35 GMT

max({<Calendar_Date={'$(=Today())'}>}FiscalPeriodNumber)

Re: Current Period

simondachstr — Thu, 16 Oct 2014 12:52:34 GMT

Create a textbox and type in the expression =today().

See if the format of today() matches your Calendar_Date field. If yes, check then if one Calendar_Date can have multiple FiscalPeriodNumbers...

Re: Current Period

its_anandrjs — Thu, 16 Oct 2014 12:56:22 GMT

Try this way also

=Max({<Calendar_Date={'$(=Max(Today()))'}>} FiscalPeriodNumber)

=Only({<Calendar_Date={'$(=Max(Today()))'}>} FiscalPeriodNumber)

Re: Current Period

simondachstr — Thu, 16 Oct 2014 12:57:27 GMT

Max(today()) ?!?

Re: Current Period

Thu, 16 Oct 2014 13:01:13 GMT

Hi,

As per anand specified expression should work if it not please check your data by taking two fields in layout whether association is coming or not..Also check fieldValue for CalendarDate..