topic Re: current week selection in qliksense in App Development

current week selection in qliksense

Saimani — Thu, 22 Apr 2021 10:27:03 GMT

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

Re: current week selection in qliksense

rubenmarin — Sat, 24 Apr 2021 08:01:17 GMT

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

Re: current week selection in qliksense

Saimani — Mon, 26 Apr 2021 09:32:17 GMT

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)

Re: current week selection in qliksense

rubenmarin — Wed, 28 Apr 2021 08:39:34 GMT

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

Re: current week selection in qliksense

Saimani — Thu, 29 Apr 2021 16:07:24 GMT

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.