Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator 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
Anil_Babu_Samineni

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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Anil_Babu_Samineni

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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
Anonymous
Not applicable

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

sunny_talwar

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