I had a fields like Fiscal Month and Fiscal year. The values consists in Fiscal year like FY13,FY14,FY15,FY16.... and Fiscal Months like Jan,Feb,Mar..etc. Here, according to my requirement i want select everytime current year value and current Month value. I tried this year(now()),year(today()), month(now()), month(today()) but it's not working for me. Could you please suggest me some more values to get the current FY year(FY16) and FY Month( Apr).
Ashok, if you want to filter by value in NPrinting, you can create a new field in the QVW that associates a value like 'today' to a date in the data model that shows dates that will include today's date
For example, in the qlik script:
today() as Today,
Year(Today()) as TodaysYear,
'F' & right(Year(Today()),2) as TodaysFiscalYear
...this would load date data from a fact table where the date =today. When a user selects a filter from this table in NPrinting, it would filter the dashboard for todays date only
Jonathan, The users just receiving the email from Nprinting. But in that mail according their requirement i had scheduled a entire dashboard. The dashboard consists of reports along with list box and all. So, They are thinking like the filters applying in Nprinting should display in the selected value of list boxes.