Qlik Community

Qlik FinServ

Announcements
Members are not receiving notifications from the community. A bug has been identified and a fix is coming soon.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Select exclude with a button

I have tried everything.  Can someone help me.  I want to have three buttons.

  • Current Month p/l (accounting month = vAcctMm)
  • Forward p/l (accounting month -= AcctMo)
  • Total p/l

I can get the current month with a toggle switch

For forward p/l, I have tried several alternatives including:

  • Select exclude
  • =Not(vAcctMo)
  • and the two scripts below

='=('&Concat({<[AccountingMonth]-={vAcctMo}>} Distinct AccountingMonth, '|') &')'

='-=('&Concat({<[AccountingMonth]={vAcctMo}>} Distinct AccountingMonth, '|') &')'

Any thoughts would be appreciated.

Tim

2 Replies
Highlighted
Partner
Partner

Hi,

if I understand correctly you want to get:

Current Month = March

Forward (Next Month) = April?

In that case try this: =Month(AddMonths(Date(Today()),+1))

Highlighted
Not applicable

I figured it out.  It was a chore.  Thanks for your reply.

Tim