Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

month

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?

14 Replies
sunny_talwar

What is the expression that you are using?

arasantorule
Creator III
Creator III

Hi,

Please use set analysis to show the result of the expression for the current month.

Thanks

PrashantSangle

Hi,

Yes you can, But for proper solutions provide more details.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
raadwiptec
Creator II
Creator II
Author

hi all ,

I have not used any expression for showing current month. But it takes the current month automatically.

sunny_talwar

Do you have the current month selected when you open the application?

awhitfield
Partner - Champion
Partner - Champion

This would be easier to advise in if you supplied an example .qvw

Andy

Anonymous
Not applicable

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

PrashantSangle

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
raadwiptec
Creator II
Creator II
Author

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