Discussion board where members can get started with QlikView.
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
Go to Solution.
Use trigger(On select) for the both year and month fields which you can found in the document properties-->Triggers tab.
Actionelect in field
Search String:=if(GetSelectedCount(Month)>0 and GetSelectedCount(Year)>0, MakeDate(Max(Year), Max(Month), 1 ))
Hope it helps
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
Check what this expression returns on selecting financial year?
Did you used the above expr or Max(FinancialYear)?
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
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 ))