Discussion board where members can get started with QlikView.
I want to find the value of a field in a table based on the value of today also in the same table.
Table (PeriodCalendar) has these fields:
So I need a variable that defines the FinPer for today
e.g. if today is 04/02/15 I want my variable to be 02
Thanks for your help
Go to Solution.
Have a look at this
View solution in original post
Define your variable as below