topic Re: Condition in QlikView

Condition

ab92 — Wed, 25 Nov 2020 16:16:04 GMT

Good afternoon every one !

Please, see below my request :

In one field, I have this :

the result end to : +375

I would like to sort the numbers present : create a condition to show the numbers between

0 to -9

-10 to -149

-150 to -499

-500 to -700

-700 to the ends from the numbers present...

I tried this but unfortunatly is not wrking : could you help me please :

load*,
if(TDM6_R<0 and TDM6_R<-10,'0 à -10',
if(TDM6_R<=-10 and TDM6_R<-150,'-10 à -149',
if(TDM6_R<=-150 and TDM6_R<-500,'-150 à -499',
if(TDM6_R<=-500 and TDM6_R<=-700,'-500 à -700','Résultat inf à -701'
)
)
)
) as Distance_Parcourue_Inf,

Many thanks for your help.

Best regards,

Axel

Re: Condition

sunny_talwar — Thu, 22 Feb 2018 14:31:27 GMT

Try this

if(TDM6_R > -10 and TDM6_R < 0, '0 à -10',
if(TDM6_R > -150, '-10 à -149',
if(TDM6_R > -500, '-150 à -499',
if(TDM6_R > -700, '-500 à -700','Résultat inf à -701')))) as Distance_Parcourue_Inf,

Re: Condition

alexandros17 — Thu, 22 Feb 2018 14:31:54 GMT

Nearly got it:

try this:

load*,
if(TDM6_R<0 and TDM6_R>-10,'0 à -10',
if(TDM6_R<=-10 and TDM6_R>-150,'-10 à -149',
if(TDM6_R<=-150 and TDM6_R>-500,'-150 à -499',
if(TDM6_R<=-500 and TDM6_R>=-700,'-500 à -700','Résultat inf à -701'
)
)
)
) as Distance_Parcourue_Inf,

Re: Condition

ab92 — Thu, 22 Feb 2018 14:39:18 GMT

HI Sunny

Many thanks for your help but it takes the number Superior to 0

it takes numbers to -142 to + 375 for the first selection -10 à -149...

Re: Condition

sunny_talwar — Thu, 22 Feb 2018 14:41:06 GMT

Then add this

if(TDM6_R > -10 and TDM6_R < 0, '0 à -10',

if(TDM6_R > -150 and TDM6_R <= -10, '-10 à -149',

if(TDM6_R > -500 and TDM6_R <= -150, '-150 à -499',

if(TDM6_R > -700 and TDM6_R <= -500, '-500 à -700',

if(TDM6_R <= -700, 'Résultat inf à -701'))))) as Distance_Parcourue_Inf,

Re: Condition

ab92 — Thu, 22 Feb 2018 14:47:00 GMT

I just tried your solution is perfect

I was very close I knew it, many thanks for your help Alessandro

Re: Condition

ab92 — Thu, 22 Feb 2018 14:52:28 GMT

Hi Dunny,

I tried also and it's working thanks a lot Dunny for your help !

Re: Condition

sunny_talwar — Thu, 22 Feb 2018 14:54:48 GMT

Dunny? Who is Dunny my friend... my name is Sunny with a S

Re: Condition

ab92 — Thu, 22 Feb 2018 15:26:53 GMT

Sorry Sunny I don't take my glasses ^^ an other question last if you the time of curse ...

I need to calculate the deviation regarding the same field : TDM6_R

I took this formul :

Stdev(TDM6_R)

But I think is not this, do you have an idea my friend ...?

Re: Condition

sunny_talwar — Thu, 22 Feb 2018 15:29:27 GMT

Where are you trying to use this? Script or front end? Also, which object if it is on the front end...

Stdev(TOTAL TDM6_R)

Re: Condition

ab92 — Thu, 22 Feb 2018 15:32:10 GMT

I using this in front in simple table :

Re: Condition

sunny_talwar — Thu, 22 Feb 2018 15:32:48 GMT

What dimensions do you have?

Re: Condition

ab92 — Thu, 22 Feb 2018 15:40:08 GMT

many I took valuelist rowno ..

in total 15 but I want just the deviation regarding each field : but the result means not good

=if(rowno()=1,Stdev([Age du patient]),

if(rowno()=2,'',

if(rowno()=3,Stdev(TDM_E1_DIST_PARCOURUE_M94),

if(rowno()=4,Stdev(TDM_E1_O2_DEBIT_DUPLIV277),

if(rowno()=5,Stdev(CSV_TDM_E2_DIST_PARCOURUE_DUPLI24),

if(rowno()=6,Stdev(CSV_TDM_E2_ENTREE_DEBITO2_DUPLI76),

if(rowno()=7,Stdev(TDM_BILAN_DISTANCE_PARCOURUE_ENTREE40),

if(rowno()=8,Stdev(TDM_BILAN_DYSPNEE_FIN_TEST_ENTREE_V268),

if(rowno()=9,'',

if(rowno()=10,Stdev(CSV_TDM_SORTIE_DISTANCE_PARCOURUE65),

if(rowno()=11,Stdev(CSV_TDM_SORTIE_DBIT_DUPLI79),

if(rowno()=12,'',

if(rowno()=13,Stdev(CSV_TDM_BILAN_DIFFER_DISTANC_ENTRE_SORT57),

if(rowno()=14,Stdev(CSV_TDM1_DYSPNEEDELTA110),

if(rowno()=15,Stdev(CSV_TDM_SORTIE_DYSPNE_653) )))))))))))))))

Re: Condition

sunny_talwar — Thu, 22 Feb 2018 15:42:26 GMT

Try adding TOTAL and see if that works

Re: Condition

ab92 — Thu, 22 Feb 2018 16:07:59 GMT

I tried and it's change nothing maybe I need to arrange something ...

Because it look extrange when the average it 425.03 and the deviation 133.45

Re: Condition

sunny_talwar — Fri, 23 Feb 2018 03:00:40 GMT

What is strange about having an average of 425.03 and stdev of 133.45? What do you think it should be?

Re: Condition

ab92 — Fri, 09 Mar 2018 15:30:09 GMT

Hi Sunny,

I just did not calculate well by my side...

Sorry for my mistake.

Thanks a lot for your help Sunny !

Great week end,

Axel