# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Contributor III

## condition

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

 Provider Group Criticité Segment SLA MAILING Critique VLV 1440 MAILING Critique LV 1440 MAILING Critique MV 1440 MAILING Critique HD 1440 MAILING Critique HV 1440 MAILING Critique Premium 1440 MAILING Critique LowEndUser 1440 MAILING Critique HighEndUser 1440 MAILING Critique Entreprise 1440 MAILING Critique One to one 1440 MAILING Non Critique VLV 4320 MAILING Non Critique LV 4320 MAILING Non Critique MV 4320 MAILING Non Critique HD 4320 MAILING Non Critique HV 4320 MAILING Non Critique Premium 4320 MAILING Non Critique LowEndUser 2880 MAILING Non Critique HighEndUser 2880 MAILING Non Critique Entreprise 2880 MAILING Non Critique One to one 1440

thanks

1 Solution

Accepted Solutions

## Re: condition

Perhaps this?

If([Provider Group] = 'MAILING' and Criticité = 'Critique' and (Segment = 'VLV' or Segment = 'LV') and SLA = 1440, 1,0)

OR

If([Provider Group] = 'MAILING' and Criticité = 'Critique' and (Segment = 'VLV' or Segment = 'LV'), 1440)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
3 Replies

## Re: condition

Perhaps this?

If([Provider Group] = 'MAILING' and Criticité = 'Critique' and (Segment = 'VLV' or Segment = 'LV') and SLA = 1440, 1,0)

OR

If([Provider Group] = 'MAILING' and Criticité = 'Critique' and (Segment = 'VLV' or Segment = 'LV'), 1440)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
New Contributor II

## Re: condition

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

tab:

Criticité,

Segment,

[               SLA]

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);

let vS='';

for i= 1 to NoOfFields('tab')

map:

\$(i) as map_field,

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

AutoGenerate 1;

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

left join(tab)