topic Re: action for button in QlikView

action for button

prabhas277 — Wed, 25 Nov 2020 16:16:04 GMT

Hi experts,

I have 2 sheets in one sheet i have one but and another sheet i have calendar .

now if i select button in one sheet then Current year until the end of last ended month ( e.g. in June 2017, from Jan 2017 until May 2017)

How to provide the action for this?

Anil_Babu_Samineni — Fri, 09 Jun 2017 06:47:06 GMT

May be create button and give action called Select in field with Field name as MonthYear and

search string is ='>=' & YearStart(Max(MonthYear),'MMM yyyy') & '<' & Date(Max(MonthYear),' MMM YYYY')

If not, I would suggest you to share application for mock up

Fri, 09 Jun 2017 06:57:44 GMT

Can You please elaborate more or share your qvw?

micheledenardi — Fri, 09 Jun 2017 07:19:13 GMT

Hi Prabhas,

this isn't an elegant solution but it works:

Hope it helps!

micheledenardi — Fri, 09 Jun 2017 09:35:42 GMT

Here you can find the qwv