5 Replies Latest reply: Mar 3, 2017 7:28 AM by Avinash R RSS

    Dynamic filter in NPrinting using expression not working properly

    Jyoti Priya

      I have created a dynamic filter based on below expressions .

       

       

      =date(addmonths(date(now(([Calendar CTD Month-Year])),'MMM YY'),-1),'MMM YY')

      The expression is getting calculated properly as I can see the value in the log. But the filter is not working in terms of generating the report with that filter . I have applied the filter at report level.

       

      I have another expression as well

       

       

      ='CY'&
      Ceil(Month(now([Calendar Cycle Rank]))/4)
      & ' '&
      date(now([Calendar Cycle Rank]),'YYYY')

       

      which is also not working . Both are working in QlikView. Please advise what is wrong here.  Please find the attachment.