This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have YearWeek, which shows values as shown below, i want to separate this into two different columns.
1. Year 2. Month, Could you please help me , how to get Year seperatly and Month Speratley
Sure PrashantSangle Sir
View solution in original post
Subfield(YearWeek,'-',1) as Year
Subfield(YearWeek,'-',2) as Month
the second value after '-' is actually week, but i want in Year as seperate field and Month as seperte field using YearWeek as source field
use makeweekdate() to convert you week into date and then from date you can easily get month & year
Month(makeweekdate(left(WeekYear,4),right(weekYear,2))) as Month,
left(WeekYear,4) as Year,
ThankYou Very Much PrashantSangle Sir
if it work for you then like that solution and select accept as solution.