topic Re: Expression Error in QlikView

Expression Error

NavinReddy — Tue, 02 Aug 2016 17:19:05 GMT

Dear Experts Good Evening,

i have used two match conditions in my expression to get different decimals for specified fact number,

one match fiction working fine , the highlighted match function not working.

please suggest me i have tried different ways i didn't get any solution.

Many Thanks,

Niru

Re: Expression Error

Siva_Sankar — Wed, 03 Aug 2016 04:09:16 GMT

Niranjan,

What is the error you are getting? Syntax error?

Regards,

Siva

Re: Expression Error

NavinReddy — Wed, 03 Aug 2016 05:30:08 GMT

Hi Siva,

Thanks for your reply,

i have tried with two match functions to get different format decimal , one match function working fine as expected.

second match function its not working not sure if any syntax error or any other way to resolve this issue.

Thanks,

Niru

Re: Expression Error

Siva_Sankar — Wed, 03 Aug 2016 05:43:05 GMT

Looks like you are missing comma or brackets somewhere in the first part of the expression. You can narrow down by writing part by part expression or try uploading your qvw file here.

--siva

Re: Expression Error

Anil_Babu_Samineni — Wed, 03 Aug 2016 06:00:36 GMT

Can you please post the Error which you got, Clue is bit important. Meantime, Please post that Expression only in the HTML format. It's looking image. How to copy that code

Re: Expression Error

NavinReddy — Wed, 03 Aug 2016 06:11:43 GMT

Hi Siva,

i have attached sample app,

can you please check where im doing wrong or any syntax changes.

best regards,

niru

Re: Expression Error

NavinReddy — Wed, 03 Aug 2016 06:12:48 GMT

Hi Anil,

i have posted sample app can you please take a look and let me know if any syntax missing.

best regards,

Niru

Re: Expression Error

Anil_Babu_Samineni — Wed, 03 Aug 2016 06:15:22 GMT

Can i know which dim you are getting trouble?

Re: Expression Error

NavinReddy — Wed, 03 Aug 2016 06:24:39 GMT

Hi, second expression im getting error there im developing the code, Thanks

Re: Expression Error

Siva_Sankar — Wed, 03 Aug 2016 06:38:24 GMT

Hi Niranjan,

why you are using same code twice for same condition..

if(Match(FCT_SETUP_ID,5795577,5805456,5805436,5805437,5805457,5794739),

if(EELE_TYPE_NM_SIGN='$',

if(ELE_VALUE_TYPE_CD = 'PCT',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT)*100,'##.000%'&' ')&'',

if(ELE_VALUE_TYPE_CD = 'QTY','$'&Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT),',###,###.0'))),

if(ELE_VALUE_TYPE_CD = 'PCT',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT)*100,'##.000%'&' ')&'',

if(ELE_VALUE_TYPE_CD = 'QTY',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT),',###,###.0')))),

if(EELE_TYPE_NM_SIGN='$',

if(ELE_VALUE_TYPE_CD = 'PCT',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT)*100,'##.00%'&' ')&'',

if(ELE_VALUE_TYPE_CD = 'QTY','$'&Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT),',###,###.0'))),

if(ELE_VALUE_TYPE_CD = 'PCT',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT)*100,'##.00%'&' ')&'',

if(ELE_VALUE_TYPE_CD = 'QTY',Num(MaxString({<Month=, MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL_VALUE_QT),',###,###.0'))))))

which number format you want for which condition, you if statement is repeating

Re: Expression Error

NavinReddy — Wed, 03 Aug 2016 07:28:37 GMT

Hi Siva,

if(Match(FCT_SETUP_ID,5795577,5805456,5805436,5805437,5805457,5794739)

for this statement im trying to adding on e additional decimal to specified number

ManyThanks,

Niru

Re: Expression Error

Siva_Sankar — Wed, 03 Aug 2016 07:57:49 GMT

Niranjan, as per the match condition and if conditon below based on the field value of ELE_VALUE_TYPE_CD , the formatting works as expected. not sure how you are saying it incorrect. sorry.

Re: Expression Error

NavinReddy — Wed, 03 Aug 2016 11:07:40 GMT

Yes you're correct for matting working fine,

but im working on adding additional decimals to listed fact number.

sorry for confusion

Many Thanks,

Niranjan

Re: Expression Error

Siva_Sankar — Wed, 03 Aug 2016 14:31:53 GMT

close the thread by marking helpful or correct, if the issue is resolved.

Re: Expression Error

NavinReddy — Wed, 03 Aug 2016 15:10:42 GMT

Hi Siva,

Sorry i have created for thread adding additional decimals to the fact number.

not sure how to resolve issue

Thanks in Advance,

Niranjan

Re: Expression Error

rubenmarin — Thu, 04 Aug 2016 06:28:53 GMT

Hi Niranjan, what FCT_SETUP_ID is not working as expected?. I didn't see any issue.

Re: Expression Error

NavinReddy — Thu, 04 Aug 2016 06:37:17 GMT

Hi Ruben,

Good Morning thank you very much for your reply,

highlighted match function FACT_SETUP_UP IDs im trying to adding the additional decimals.

i am not able to do.please help me.

Many Thanks,

Niranjan

Re: Expression Error

rubenmarin — Thu, 04 Aug 2016 06:41:47 GMT

Hi, I know, but wich one is not working as expected? 5795577? 5805456?... Please post an image of the table wich value shows incorrect.

Re: Expression Error

NavinReddy — Thu, 04 Aug 2016 06:49:47 GMT

All below listed ids not working for these facts i want to display 3 decimals,

(FCT_SETUP_ID,5795577,5805456,5805436,5805437,5805457,5794739)

Best Regards,

Niranjan

Re: Expression Error

rubenmarin — Thu, 04 Aug 2016 06:55:34 GMT

What you have in that match is:

If ELE_VALUE_TYPE_CD='QTY' --> 1 decimal

If ELE_VALUE_TYPE_CD='PCT' --> 3 decimals

If you want 3 decimals also when ELE_VALUE_TYPE_CD='QTY' you should set the format of that condition with 3 decimals:

'###,###.0' --> to --> '###,###.000'