topic Error when comparing a field with two other field values. in QlikView

Error when comparing a field with two other field values.

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

Hi all,

I think, i am missing something, if any one can point out the error i am doing, it will be great.

I want a calculation like this

sum({<ID_PERIOD = {">=0"}, ID_PERIOD = {"<=2078052"}>}QTE_VENDU)

I want to compare the ID_PERIOD falls between VALUE1 and VALUE2

When i enter the values directly it works. but they are fields in table so i did these two things

sum({<ID_PERIOD = {">=P(SAIS_SEM_DEB)"}, ID_PERIOD = {"<=P(SAIS_SEM_FIN)"}>}QTE_VENDU)

sum({<ANNEE_SEMAINE=, ID_PERIOD={"'>='&P(SAIS_SEM_DEB)&'<='&P(SAIS_SEM_FIN))"}>} QTE_VENDU)

Both brings 0 Sum value.

Thanks in advance for your help.

Regards

Jegadish

Re: Error when comparing a field with two other field values.

olivierrobin — Wed, 25 Apr 2018 09:48:10 GMT

hello

it could mean that your 2 fields do not contain the values you think

try to display them in text boxes , select the period you want and look at the values

Re: Error when comparing a field with two other field values.

Nagaraju_KCS — Wed, 25 Apr 2018 10:19:17 GMT

Hi,

Expressions seems to be correct, can you post some sample data..

Re: Error when comparing a field with two other field values.

Anonymous — Wed, 25 Apr 2018 21:25:02 GMT

i want to calculate the quantity (QTE_VENDU) when the ID_PERIOD falls between SAIS_SEM_DEBUT and SAIS_SEM_FIN irrespective of my period selection.

i used this expression

sum({<ID_PERIOD = {">=P(SAIS_SEM_DEB)"}, ID_PERIOD = {"<=P(SAIS_SEM_FIN)"}>}QTE_VENDU)

= 0

when i use a hard value

sum({<ID_PERIOD = {">=0"}, ID_PERIOD = {"<=2078052"}>}QTE_VENDU)

It works correctly

Not able to find the error, help appreciated.

Re: Error when comparing a field with two other field values.

Anonymous — Thu, 26 Apr 2018 07:51:58 GMT

After going through the community discussion.

I created a field with Recno() named as rec_num and then used the set analysis tool generator to solve my problem.

Sum({$<ANNEE_SEMAINE=,REC_NUM=P({1<ID_PERIOD={">=$(=P(SAIS_SEM_DEBUT_))"}>}REC_NUM), REC_NUM=P({1<ID_PERIOD={"<=$(=P(SAIS_SEM_FIN_))"}>}REC_NUM)>}QTE_VENDU)