Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator 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
Highlighted

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.

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

Re: values comparaison

any help please ?

Highlighted

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')

Highlighted

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)
Highlighted

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.

View solution in original post