Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show most recent data in Qlik Sense

Hi everyone,

I want to set an action that basically everytime when I open my Qlik Sense app, it will show me all my graphs in the most recent data (month and year, not date). I know how to do this in QlikView (document properties - triggers) but I don't know how can I do it in Qlik Sense or what other alternatives do you suggest?

For example, using max(year) and max(month) in all my formulas.. like this Sum({$<Year={$(=Max(Year))}>}sales)... is there a better/quicker way?

Thanks!!!!!

trig.JPG

15 Replies
Not applicable
Author

the link doesn't work

Not applicable
Author

i cant understand u, i dont puted any link in the post.

Not applicable
Author

Attached is the screen shot from your post about the extension to default the values at start of the App. I tried and it doesn't work.  DO you have a qvf where u are using this extension?        

Not applicable
Author

Write a formula into your charts to set filter conditions

You can use GetSelectedCount in an if statement to check if a filter is present, if not, write set analysis statement to set your charts to the current year, month variable.

Not applicable
Author

Below extension is a perfect solution.  You can create a book mark  that will load at startup of the application

http://branch.qlik.com/#!/project/56b8b46a3247b4e06119eb5a

Not applicable
Author

here u can find the option that i told u.

http://branch.qlik.com/#!/project/56728f52d1e497241ae698a0

regards!!