Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

master_student
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 GroupCriticitéSegment               SLA
MAILINGCritiqueVLV1440
MAILINGCritiqueLV1440
MAILINGCritiqueMV1440
MAILINGCritiqueHD1440
MAILINGCritiqueHV1440
MAILINGCritiquePremium1440
MAILINGCritiqueLowEndUser1440
MAILINGCritiqueHighEndUser1440
MAILINGCritiqueEntreprise1440
MAILINGCritiqueOne to one1440
MAILINGNon CritiqueVLV4320
MAILINGNon CritiqueLV4320
MAILINGNon CritiqueMV4320
MAILINGNon CritiqueHD4320
MAILINGNon CritiqueHV4320
MAILINGNon CritiquePremium4320
MAILINGNon CritiqueLowEndUser2880
MAILINGNon CritiqueHighEndUser2880
MAILINGNon CritiqueEntreprise2880
MAILINGNon CritiqueOne to one1440

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)

View solution in original post

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)

View solution in original post

leledifrapwc
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:

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;

NEXT

Re: condition

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