Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Current Period

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 !!!!!!

1 Solution

Accepted Solutions

Re: Current Period

Try this way also

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

Or

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

8 Replies

Re: Current Period

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

Not applicable

Re: Current Period

it returning null value.

Re: Current Period

Provide sample data please..

Not applicable

Re: Current Period

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

simondachstr
Valued Contributor III

Re: Current Period

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

Try this way also

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

Or

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

simondachstr
Valued Contributor III

Re: Current Period

Max(today()) ?!?

Not applicable

Re: Current Period

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..

Community Browser