How to make auto selection on today's date without manual

[rammuthiah]

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).

[sravan_v007]

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.

[beck_bakytbek]

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

[rammuthiah]

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?

[beck_bakytbek]

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

[tomasz_tru]

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.

[rammuthiah]

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.

[rammuthiah]

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.

[tomasz_tru]

Proper set analysis function will give you maximum date calculated - nothing wił be locked.

[Anonymous]

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