topic Re: Buttons in qliksense in App Development

Buttons in qliksense

khadar — Tue, 22 Mar 2022 03:51:37 GMT

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.

Re: Buttons in qliksense

durgesh22 — Tue, 22 Mar 2022 06:31:03 GMT

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))'

Re: Buttons in qliksense

durgesh22 — Tue, 22 Mar 2022 06:35:36 GMT

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

Re: Buttons in qliksense

khadar — Tue, 22 Mar 2022 10:16:21 GMT

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

Re: Buttons in qliksense

durgesh22 — Tue, 22 Mar 2022 13:59:12 GMT

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 .

Re: Buttons in qliksense

khadar — Fri, 08 Apr 2022 09:25:41 GMT

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