Discussion Board for collaboration related to QlikView App Development.
I wanna transform this table into conditions (a calculated dimension):
if provider_group ='Mailin' and criticte='Critique' and segment =VLV or segment='LV' then SLA=1440
and so on
Go to Solution.
If([Provider Group] = 'MAILING' and Criticité = 'Critique' and (Segment = 'VLV' or Segment = 'LV') and SLA = 1440, 1,0)
If([Provider Group] = 'MAILING' and Criticité = 'Critique' and (Segment = 'VLV' or Segment = 'LV'), 1440)
View solution in original post
that way you can import the fieldnames into your table by creating a column for each name..maybe that helps
LOAD [Provider Group],
(ooxml, embedded labels, table is Sheet1);
for i= 1 to NoOfFields('tab')
$(i) as map_field,
fieldname($(i),'tab') as campo
ApplyMap('map',$(i)) as field_$(i)
What do you mean a calculated dimension... what is SLA= 1440 means here? and "so on" how do you expect us to interpret that