AUTO SELECTED MAX FROM SYSDATE FIELD IN QLIKSENSE

[zain16nib]

Hi,

I have a column name Sysdate which has incremental daily dates used for selection to view the details of the clients.

My requirement is when the Qliksense application has open the Sysdate field automatically selected the max date from Sysdate by default.

I used a bookmark for this but failed, in the field search I used the given expression  =Sysdate=max(Sysdate) its show me the result but it put the value in the bookmark  set expression  =Sysdate=21 MAR 2020, not as an expression.

Regards,

Zain.

[tresesco]

Try like:

=Sysdate=max( total Sysdate)

[zain16nib]

same result,

how we change the bookmark set expression, it only gives a copy of the expression.

Regards,

Zain

[tresesco]

Why are you using set expression? Could you share a screen shot showing what and how you are doing? 

[zain16nib]

Dear thanks for your replies,

I have unchecked always one selected value in the field setting and use the variable (max value) in the table object expression without a bookmark and its working fine for me.

Regards,

Zain