topic Re: values comparaison in QlikView

values comparaison

master_student — Wed, 15 Nov 2017 10:24:57 GMT

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 ='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 :

Re: values comparaison

master_student — Thu, 16 Nov 2017 09:37:09 GMT

any help please ?

Re: values comparaison

avinashelite — Thu, 16 Nov 2017 09:46:30 GMT

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

Anil_Babu_Samineni — Thu, 16 Nov 2017 09:48:32 GMT

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

Re: values comparaison

PrashantSangle — Thu, 16 Nov 2017 10:23:13 GMT

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,