Discussion board where members can get started with Qlik Sense.
I have table like....
I want create the variable for Current Year . Please suggest me how to create the variable for that?
do you whant the age ??
age(Now(),DateOfBirth) as age
or you whant the year from StartDate ?
Year(StartDate) as year
may you explane
Let vYear = Year(Today());
Let vYear1 = Year(Date(Today(), 'MM/DD/YYYY'));
Your first expression is OK, but the Date formatting function here:
is completely superfluous.
Hi bala, r u from bangalore.