topic Re: Button Selection with Actions in QlikView

Button Selection with Actions

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

Hello,

I want to show only current year and current month when user click the button

Lets assume, i have data like below

Date Sales

01/01/2016 10

01/05/2016 20

01/01/2015 20

01/01/2014 30

01/01/2013 40

01/01/2012 50

01/01/2011 60

01/01/2010 70

Here, I want to create when user click the Button then i want to show data which related to

Max(Year) - Current Year

Current Max Month

How to add this actions into button?

Please help me

Anonymous — Wed, 06 Jul 2016 17:31:59 GMT

At Back End only, create a field as

num(monthname(Date)) as MOnthname_Num

Now in properties of a buttoon define an action as

Select in Field >>

Field>> Monthname_Num

VAlue>> max(Monthname_Num)

This way the data in chart will always reflect for selected or the max year month....

reards

Nitin

Anil_Babu_Samineni — Wed, 06 Jul 2016 17:33:09 GMT

Can you please send the qvw

sunny_talwar — Wed, 06 Jul 2016 17:33:32 GMT

I would use a date field to do this

='>=' & Date(MonthStart(Max({1}Date)), 'MM/DD/YYYY') & '<=' & Date(MonthEnd(Max({1}Date)), 'MM/DD/YYYY')

Assuming your date format is MM/DD/YYYY and not DD/MM/YYYY

sunny_talwar — Wed, 06 Jul 2016 17:35:15 GMT

Sample attached

Anil_Babu_Samineni — Wed, 06 Jul 2016 17:37:05 GMT

Thanks Sunny