topic Re: Script problem in QlikView

Script problem

vipin_mishra479 — Wed, 29 Aug 2012 06:41:20 GMT

I have given a some script part in this script i have using a group by function and this function + , - are working but when i try to divide two fied is not working

i have attached the script in docx.

Re: Urgent requirement

sreenivas — Wed, 29 Aug 2012 06:47:49 GMT

In this script there is no division

Re: Script problem

Anonymous — Wed, 29 Aug 2012 06:58:14 GMT

sreenivas is correct - you have not posted the part which you are saying is not working..

anyways.. are you trying to say that the division script is not working if you try in a similar fashion like the below..

sum(if(DESCRIPTION2='Sales',Amount))* sum(if(DESCRIPTION2='COGS',Amount)) as Amount,

sum(if(DESCRIPTION2='Sales',Amount))/ sum(if(DESCRIPTION2='COGS',Amount)) as Amount,

can also post what happens when you try to divide..

Re: Urgent requirement

vipin_mishra479 — Wed, 29 Aug 2012 06:58:14 GMT

but when i divide by 2 its working.

Re: Script problem

vipin_mishra479 — Wed, 29 Aug 2012 06:59:57 GMT

thanks for the reply

but when i divide or multiply the out put is blank.

Re: Script problem

Anonymous — Wed, 29 Aug 2012 07:58:21 GMT

well.. i can suggest you run a check first on the data..

create a script like the below, put a table of the three fields and then check all the three fields...

sum(if(DESCRIPTION2='Sales',Amount))* sum(if(DESCRIPTION2='COGS',Amount)) as Amount,
sum(if(DESCRIPTION2='Sales',Amount)) as SalesAmount,
sum(if(DESCRIPTION2='COGS',Amount)) as COGSAmount,

Re: Script problem

vipin_mishra479 — Wed, 29 Aug 2012 11:37:25 GMT

salesAmount and CogsAmount are come correct but Amount comes are wrong.

Re: Script problem

sreenivas — Wed, 29 Aug 2012 11:47:10 GMT

Check this file