topic condition in QlikView

condition

master_student — Wed, 08 Nov 2017 10:26:14 GMT

Hello Guys,

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

thanks

Anil_Babu_Samineni — Wed, 08 Nov 2017 11:28:37 GMT

Perhaps this?

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)

Anonymous — Wed, 08 Nov 2017 12:01:27 GMT

that way you can import the fieldnames into your table by creating a column for each name..maybe that helps

tab:

LOAD [Provider Group],

Criticité,

Segment,

[ SLA]

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);

let vS='';

for i= 1 to NoOfFields('tab')

map:

mapping LOAD

$(i) as map_field,

fieldname($(i),'tab') as campo

AutoGenerate 1;

let vStringa=concat(fieldname($(i),'tab'),'-');

left join(tab)

LOAD *,

ApplyMap('map',$(i)) as field_$(i)

Resident tab;

sunny_talwar — Wed, 08 Nov 2017 12:20:15 GMT

What do you mean a calculated dimension... what is SLA= 1440 means here? and "so on" how do you expect us to interpret that