Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
master_student
Contributor III

values comparaison

hello Guys,

I need your help,

I have two expression

sss: Interval(Interval#(SLA_INTERM, 's'), 'm')

=If(

ser ='Bo Facturation' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

), 2880,

if(ser ='Bo Facturation' and (

segment= 'LowEndUser'

or segment='HighEndUser'

or segment='Entreprise'

or segment='One to one'

), 1440,

if (

ser ='BO TECKNO ' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

or segment ='LowEndUser'

or segment ='LowEndUser'

or segment ='HighEndUser'

or segment ='Entreprise'

or segment ='One to one'

), 1440

,

if (

ser ='DT Support +Fixe + Delivery' and (

segment= 'VLV'

or segment='LV'

or segment='MV'

or segment='HV'

or segment='HD'

or segment='Premium'

), 2880

,

if (

ser ='DT Support +Fixe + Delivery' and (

segment= 'LowEndUser'

or segment='HighEndUser'

or segment='Entreprise'

or segment='One to one'

), 1440

and a fields that compare the two values, the problem is that : if(Column(1)>Column(2),'Hors Delais','Dans les delais')

the problem is there values of column 1 superior to the values of cloumn 2 but the text displays : Dans les delais :


Capture.PNG

1 Solution

Accepted Solutions

Re: values comparaison

good catch anil

looks like he is comparing interval formatted value with numeric value.

master_student

for your information interval function is a formatting function. It not converted the value of it

You can modify your 1st expression like below and try

sss: num(num#(Interval(Interval#(SLA_INTERM, 's'), 'm')))


Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
4 Replies
master_student
Contributor III

Re: values comparaison

any help please ?

Re: values comparaison

check the order of the expression ?? share the sample app that will help us to identify the issue ..


OR directly use the Expression name in the if condition like

if(Expname1>Expname2,'Hors Delais','Dans les delais')

Re: values comparaison

Better if you provide sample to check, Because the input image is wrong as output receiving.

Are you estimating 2880, 1440, 1440, 2880, 1440 are the minutes?

If so, I could ask you to write something like

Interval(2880, 'mm')

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)

Re: values comparaison

good catch anil

looks like he is comparing interval formatted value with numeric value.

master_student

for your information interval function is a formatting function. It not converted the value of it

You can modify your 1st expression like below and try

sss: num(num#(Interval(Interval#(SLA_INTERM, 's'), 'm')))


Regards,

Great dreamer's dreams never fulfilled, they are always transcended.