Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Join us on Feb.12 to Discover what’s possible with embedded analytics: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
khadar
Contributor III
Contributor III

Buttons in qliksense

Hi Team,

I need a small on how to create a logic to develop buttons for lastweek & Current week.

when user click on lastweek button whole lastweek start from monday to sunday  all dates should get selected and data has to be updated as per those dates,

similry  for currentweek button too.

 

Labels (1)
1 Solution

Accepted Solutions
durgesh22
Creator
Creator

Please convert expression--> ='>=$(=WeekStart(today()))<=$(=today())' to the format of the field on which you are going to apply filter. it is working as expected .

durgesh22_0-1647957536462.png

 

View solution in original post

5 Replies
durgesh22
Creator
Creator

Try below, it should work

 

Current week Button--

Action-- Select Value Matching search Criteria

Field--Date field

Value--      ='>=$(=WeekStart(today()))<=$(=today())'

 

Last week Button--

Action-- Select Value Matching search Criteria

Field--Date field

='>=$(=WeekStart(today(),-1))<=$(=Weekend(today(),-1))'

durgesh22
Creator
Creator

Add one more action of clearing selection in field before select value action for each button

khadar
Contributor III
Contributor III
Author

Hi Durgesh,

Thank you for helping me. I tried above result is getting in number format like37581of 38034.

and for we weekstart function in not working in front end 

durgesh22
Creator
Creator

Please convert expression--> ='>=$(=WeekStart(today()))<=$(=today())' to the format of the field on which you are going to apply filter. it is working as expected .

durgesh22_0-1647957536462.png

 

khadar
Contributor III
Contributor III
Author

Thank you so much for you help Durgesh. This logic worked for me a lot