current week selection in qliksense

[Saimani]

Hi Everyone,

I am having an qliksense app containing of Map chart and Table chart  .

when i open the app the data present in that should be of max week  which means the map chart and table chart should display max week data.

I applied default selection and bookmark but its not working

if any one have alternative idea please share me ASAP

[rubenmarin1]

Hi, you can create a yearweek field in script like: Year(DateField) & Num(Week(DateField),'00') as NumYearWeek.

Then you can use this field in set analysis like: Sum({<NumYearWeek={$(=Max(NumYearWeek))}>} FieldtoSum)

This will filter expression to return the max selcted week, if you want to always show the higher week ignoring selections you can use a set analysis like: {<NumYearWeek={$(=Max({1}NumYearWeek))}>}

Set analysis has to be set in all expression to work, you can try with one and when it works as you expect translate it to other expressions

[Saimani]

Thanks for the information.

But when i load the application entire application is to be reflected with max week data.

(similar to document triggers in qlikview)

[rubenmarin1]

Hi, check this: https://community.qlik.com/t5/App-Development/Default-Max-Date-selection-in-Filter-pane-when-app-ope...

[Saimani]

Thanks for the information ruben,

By applying default bookmark selection iam getting max year and max week for old data.

but when i update new data in the load script , iam not getting the latest year and week selection.