Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!!!
the link doesn't work
i cant understand u, i dont puted any link in the post.
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?
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.
Below extension is a perfect solution. You can create a book mark that will load at startup of the application
here u can find the option that i told u.
http://branch.qlik.com/#!/project/56728f52d1e497241ae698a0
regards!!