Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear experts,
I am trying to figure this problem out with a load script which I currently have.
One of the field in the table is known as date.
it contains:
2017 P01
2017 P02
.
.
2017 P012
2015 Q1 FC
2015 Q2 FC
2015 Q3 FC
2015 Q4 FC
2015 Q1 FC pm
2015 Q2 FC pm
2015 Q3 FC pm
2015 Q4 FC pm
2016 Q1 FC
2016 Q2 FC
2016 Q3 FC
2016 Q4 FC
I would like to extract the dates starting with the Q1-4 into one a field, and another field with the Q1-4 FC PM.
the pseudo code and syntax which i am trying to use is this:
if(subfield(date, ' ',2)="*Q*", keep the selected values) as financial quarter FC
Your help with this matter is greatly appreciated!
Kind regards,
Royce Tang
if(left(subfield(Date,' ',2),1)='Q'),mid(Date,index(Date,' ',1)) as FC
if(left(subfield(Date,' ',2),1)='Q'),mid(Date,index(Date,' ',1)) as FC
that worked perfectly, and I even learnt 2 new functions left and mid ! cheers buddy you have been a great help.
May I please ask where did you learn your qlikview skills from? or they just come with time and experience ?