Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
its_anandrjs

Try this way also

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

Or

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

View solution in original post

8 Replies
MK_QSL
MVP
MVP

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

Not applicable
Author

it returning null value.

MK_QSL
MVP
MVP

Provide sample data please..

Not applicable
Author

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

simondachstr
Luminary Alumni
Luminary Alumni

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

its_anandrjs

Try this way also

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

Or

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

simondachstr
Luminary Alumni
Luminary Alumni

Max(today()) ?!?

Not applicable
Author

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