Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The data gets reloaded daily. I want to show today's sale by making lock on Today's date. Is it possible? How to make auto selection on today's date without manual (lock in Qlik Sense).
I found one extension. But need to click on the first time, whenever open for the day.
Sheet Navigation & Actions Extension
We don't have triggers option in Qlik Sense.
So, you have to find a extension for this..
Check Climber KPI(it's a extension). Using this you can navigation button sheets and at the same time select a value from a field(i.e. Select in Field) same as Qlikview Actions.
Hi Ram,
look at this
https://community.qlik.com/docs/DOC-18512
you will need the extension: sheetevent. go to QlikBranch
if you dont find this extension, let me know
i hope that helps
Beck
Thanks for the reply, Beck. But as per my requirement.
Maximum date should be locked. For instance, Today's date is : 07/21/2017 is the max date. So I locked. But when I reload data manually, the max date will be 07/22/2017(max date). But here I locked the max date as 07/21/2017.
Getting my point?
Can anyone help in this regard?
Hi Ram,
what kind of data do you use or what kind of master calender?
if you have an extension, you can make in selections: for instance: Year(Today) and always if you open your app, the actual date will be selected.
Beck
Is it necessary to do it by selection? You can use Set Analysis in your measure to show only numbers for the last date available.
Date is from db and I am not using Master Calendar script.
Consider the column Date as Today's Date from database(i.e) 22/07/2017 is the maximum date. Now I am locking the maximum date (22/07/2017). But, when I reload the data by tomorrow, 23/07/2017 will be the maximum date. But I have locked 22/07/2017 considered as maximum. Instead of choosing maximum date, I have to show all the dashboard by default selection as Maximum date.
Date is from db and I am not using Master Calendar script.
Consider the column Date as Today's Date from database(i.e) 22/07/2017 is the maximum date. Now I am locking the maximum date (22/07/2017). But, when I reload the data by tomorrow, 23/07/2017 will be the maximum date. But I have locked 22/07/2017 considered as maximum. Instead of choosing maximum date, I have to show all the dashboard by default selection as Maximum date.
Proper set analysis function will give you maximum date calculated - nothing wił be locked.
Hi Ram,
How you are locking the maximum date here,
- Is it from the max date of your transactions or only max of Sys date, in both the cases if you can use Set analysis by using Date={$(=max(Date))} in expression this will gives you the solution.
this may helps
Regards,
Sadasiva