Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

AUTO SELECTED MAX FROM SYSDATE FIELD IN QLIKSENSE

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.

 

 

Labels (1)
4 Replies
Highlighted
MVP
MVP

Try like:

=Sysdate=max( total Sysdate)

Contributor III
Contributor III

same result,

 

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

 

Regards,

 

Zain

Highlighted
MVP
MVP

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

Highlighted
Contributor III
Contributor III

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