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

[rammuthiah]

Sometimes want to show for all dates or maximum date. So that I have locked for maximum date by manually.

[rammuthiah]

It's from data. I can select maximum date, but here I wants to show all sheets by either maximum date or for all dates. So I locked the maximum date by selection in Filter pane by manually. In case, if I reload the data tomorrow, the selection for maximum date for today, will get disappeared because of maximum date will get changed to tomorrow's date.

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 selecting the maximum date, I have to show all the dashboard by default selection for Maximum date.

[Anonymous]

Hi Ram,

It's better to build a logic to show all the Data points to YTD and Last year to date, if you want to see the all data you can select year filter for all.

For example

Sum({<Year = {$(=max(Year))},YearMonth = {"<=$(=max(YearMonth))"}>} [Net Sales])

This set will gives me the data for YTD

to see the all date we can use a KPI to give Sum(sales)

Regards,

Sadasiva

[Anonymous]

Sorry forgot to add date in set for till date.

[arvind_patil]

HI Ram,

Use set analysis for achieving this and use Max String Function for date filed.

Thanks,

Arvind Patil

[rammuthiah]

I have done that way. But requirement is like mentioned above. Selection should be locked only for the first time and the lock should be automized the maximum date for every day.

[rammuthiah]

Hi Tomasz,

Is there any way to show dashboard based on maximum date and not by set analysis. I reloaded the data by today. And it shows the max date as 26/07/2017. I have locked that maximum date.

Again, I have to reload the data by tomorrow, the maximum date will get changed. But I need the selection as maximum date. Sometimes I have unlocked the maximum date to show overall performance. Kindly help to get the solution

[tomasz_tru]

Sorry, out of ideas...

[beck_bakytbek]

Hi Ram,

i dont see your point, my question is, did you tried to work with extension that i sent to you.

or give me your example data, i create an example and give you the solution

Beck

[OmarBenSalem]

Try to use a set expression :

exp:

sum({<Date={"$(=Today())"}>}sales)

Or

sum({<Date={"$(=max(Date))"}>}sales)

with that, you'll be sure to work with only the max date without having to fix it.

Now, if you want to force default selections in Qlik Sense, please take a look at this thread:

https://qliktech.hosted.jivesoftware.com/thread/254619