topic Re: Display Most recent Note in QlikView

Display Most recent Note

cbaqir — Thu, 02 Feb 2017 22:48:57 GMT

I need to auto-display a note with NOTE_TYPE = 'TOP' and EXP_TYPE_CODE = 'Capital' for the most recent month as defined by

vCurGLMonth.

I would also like the FISCAL_MONTH_YEAR selection across the stop (7/16, 8/16...) to automatically have the vCurGLMonth selected.

This is not working:

=date(FISCAL_MONTH_YEAR, 'MMM-YYYY') & ' ' & only({<[NOTE_TYPE] = {'TOP'},EXP_TYPE_CODE={'Capital'}>}NOTE)

Please help.

Re: Display Most recent Note

sunny_talwar — Thu, 02 Feb 2017 22:53:08 GMT

Would you be able to give an example of what you would see when you select 08/16 for example?

Re: Display Most recent Note

cbaqir — Fri, 03 Feb 2017 15:54:17 GMT

Re: Display Most recent Note

sunny_talwar — Fri, 03 Feb 2017 16:02:44 GMT

I think there is something wrong with your data model..... When I select EXP_TYPE_CODE (Capital)... I still see both capital and Operating note and that is why the Only expression isn't working...

Workaround?

=date(FISCAL_MONTH_YEAR, 'MMM-YYYY') & ' ' & only({<[NOTE_TYPE] = {'TOP'},NOTE={'*Capital*'}>}NOTE)

But you may want to fix the data model

Re: Display Most recent Note

cbaqir — Fri, 03 Feb 2017 16:09:37 GMT

Oops. You are right. Here is the file with the fixed join. I still am trying to figure out how to automatically display the note associated with the vCurGLMonth.

Re: Display Most recent Note

sunny_talwar — Fri, 03 Feb 2017 16:15:14 GMT

This?

=date(Only({<TRX_DATE = {"$(=vCurGLMonth)"}>}FISCAL_MONTH_YEAR), 'MMM-YYYY') & ' ' & only({<[NOTE_TYPE] = {'TOP'},EXP_TYPE_CODE={'Capital'}, TRX_DATE = {"$(=vCurGLMonth)"}>}NOTE)

Re: Display Most recent Note

cbaqir — Fri, 03 Feb 2017 16:24:34 GMT

Halfway there. Thanks. 2 more questions...

So the note populates but how do I show the month/year selection at the top with the vCurGLMonth?

This isn't working as a document trigger:

Also, how can I restrict the month selections to only allow one month to be selected at a time? My calculations won't work if multiple months are selected -per the requestor's design.

Re: Display Most recent Note

sunny_talwar — Fri, 03 Feb 2017 16:34:02 GMT

Added a button to for the trigger to work...

Created a list box object for FISCAL_MONTH_YEAR and made it always one value selected

Re: Display Most recent Note

cbaqir — Fri, 03 Feb 2017 16:40:15 GMT

Thanks. I was using an expression for my date list box so the Always Select One Value option wasn't there.

Thanks for the right trigger syntax =Only({<TRX_DATE = {"$(=vCurGLMonth)"}>} FISCAL_MONTH_YEAR)