I have such a prosaic problem.How do I create a variable that will contain the month in the form "YYYY/MM"?
I have let xxx = peek ('abc') where abc is the month in the correct format.But a variable divides two numbers by itself instead of keeping them as text.I also tried SET instead of LET but then peek doesn't work.
I am not sure if I understand what you want to achieve. Do you have only month as field in your data model? If you also have a date, you could well extract "YYYY/MM" from the date field and then create a variable to contain that new field (ex: YearMonth)
Load *, year(Date) & '/' & Month(Date) as YearMonth
Hi @qlikeers , To make it easy, share your qvf (make it very sample, few lines in scripts + 1 sheet showing the value-result of used variable). I am not sure to check it directly because I am busy today. /joseph