Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Sumit kumar thakur

If i select year and month, is it possible that the first day of that month and year gets selected automaticallly.

if yes give the solution

1 Solution

Accepted Solutions
celambarasan
Not applicable

Sumit kumar thakur

Hi,

     Use trigger(On select) for the both year and month fields which you can found in the document properties-->Triggers tab.

     ActionSmiley Frustratedelect in field

     Field NameSmiley Very HappyateField

     Search String:=if(GetSelectedCount(Month)>0 and GetSelectedCount(Year)>0, MakeDate(Max(Year), Max(Month), 1 ))

Hope it helps

Celambarasan

5 Replies
celambarasan
Not applicable

Sumit kumar thakur

Hi,

     Use trigger(On select) for the both year and month fields which you can found in the document properties-->Triggers tab.

     ActionSmiley Frustratedelect in field

     Field NameSmiley Very HappyateField

     Search String:=if(GetSelectedCount(Month)>0 and GetSelectedCount(Year)>0, MakeDate(Max(Year), Max(Month), 1 ))

Hope it helps

Celambarasan

Not applicable

Sumit kumar thakur

The answer u have given me works correctly when i select monthname and year, but when i select financialyear instead of normal year it gives the following result ---

i select financial year = 2009-2010 and month = sep , it show 01/09/39904

celambarasan
Not applicable

Sumit kumar thakur

Hi,

     Check what this expression returns on selecting financial year?

     =Max(Year)

     Did you used the above expr or Max(FinancialYear)?

Celambarasan

Not applicable

Sumit kumar thakur

i have try out this expression

if(GetSelectedCount(MonthName)>0 and GetSelectedCount(FinancialYear)>0, MakeDate(Max(FinancialYear), Max(MonthName), 1 ))

and output is 01/09/39904

celambarasan
Not applicable

Sumit kumar thakur

Hi,

     Do you have a year field?

     if so use that year field instead of Financial Year.

     Check with the below expr.

if(GetSelectedCount(MonthName)>0 and GetSelectedCount(FinancialYear)>0, MakeDate(Min(Year), Min(MonthName), 1 ))

Celambarasan