Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have a chart which needs to display only the previous months data based on a specific column transaction date.
whenever reopen the chart it shows current month. can I change it to previous month
suggest?
What is the expression that you are using?
Hi,
Please use set analysis to show the result of the expression for the current month.
Thanks
Hi,
Yes you can, But for proper solutions provide more details.
Regards,
hi all ,
I have not used any expression for showing current month. But it takes the current month automatically.
Do you have the current month selected when you open the application?
This would be easier to advise in if you supplied an example .qvw
Andy
Hi,
if current month is not selected or no expression for filtering current month.
maybe data is for only current month is loaded.
Have you checked if there is data other than current month?
Check load script for filters on time dimension?
Regards
Neetha
Hi,
Just check is there any on open trigger set in sheet
also confirm that while closing document did you made any selection in calendar...
Regards,
hi sunny ,
yes current month gets selected when I open the report and is highlighted
for ex: month and year are as list boxes.. so it select 2016 and 01 gets highlighted