If statement to create a separate field by unique identifier
I am trying to create three new fields from a field named [value] parsed by a unique identifier called [series_id]. I am using a RESTConnector to pull the data from an official source (BLS.gov). I am pulling multiple series at once, which I hope to parse out within Qlik to use as separate dimension in the visualization tool.
The three new fields will be named [Alabama], [Alaska], and [Arizona]. In this process, I hope to populate data from [value] into each of these new fields using [series_id].
I've attached my QVF. Here is the Load step that includes the IF statement.
LOAD [year] AS [year],
[period] AS [period],
Date(Makedate([year],right([period],2)), 'MMMYYYY') as MONTHYEAR,
Date(Makedate([year],right([period],2)),'M/D/YYYY') as DATE,
[value] AS [value],
If([seriesID] = 'SMS01000000000000001',[value]) as [Alabama],
If([seriesID]='SMS02000000000000001', [value]) as [Alaska],
If([seriesID]= 'SMS04000000000000001', [value]) as [Arizona],