topic Re: Error in formula... in QlikView

Error in formula...

danialier — Fri, 28 Feb 2014 14:09:28 GMT

Hello,

For some reason the formula below does not work... What I want is to have the result of doing; units from CompanyA in the last period (so the current period) minus units from CompanyZ in the previous period.

=num(sum({<Vendor={'CompanyA'},Period={$(=Max(Period))}>}units)-sum({<Vendor={'CompanyA'},Period={$(=Max(Period)-1)}>}units))

thks,dani

Re: Error in formula...

Fri, 28 Feb 2014 14:13:19 GMT

try this :

=num(sum({$<Vendor={'CompanyA'},Period={'$(=Max(Period))'}>}units)-sum({$<Vendor={'CompanyA'},Period={'$(=Max(Period)-1)'}>}units))

Re: Error in formula...

MK_QSL — Fri, 28 Feb 2014 14:26:14 GMT

Use as per below to get the Grown in Unit compare to last month.

=num(sum({<Vendor={'CompanyA'},Period={"$(=Max(Period))"}>}units)-

sum({<Vendor={'CompanyA'},Period={"$(=Max(Period)-1)"}>}units))

Also make sure that your format of your Period and $(=Max(Period)-1) should be same.

Re: Error in formula...

Peter_Cammaert — Fri, 28 Feb 2014 14:35:38 GMT

I guess the CompanyZ you're referring to in your question is a typing mistake?

Peter

Re: Error in formula...

Anonymous — Fri, 28 Feb 2014 14:35:49 GMT

the error could be in the Period={$(=Max(Period))}>} because you can try like this by seeing below syntax

syntax 1: DayOfYear = {"<=$(=max({<FiscalYear={$(=vCY)}>} DayOfYear))"}

If it does not work please post the qvw file it would be easy to solve.

Re: Error in formula...

santharubban — Fri, 28 Feb 2014 20:58:07 GMT

try this

=num(sum({<Vendor={'CompanyA'},Period={'$(=Max(Period))'}>}units)-

sum({<Vendor={'CompanyA'},Period={'$(=Max(Period)-1)'}>}units))

Re: Error in formula...

aveeeeeee7en — Fri, 28 Feb 2014 21:07:11 GMT

Hi Dani

Try this:

=num(sum({<Vendor={'CompanyA'},Period={'$(=Max(Period))'}>}units))

num(sum({<Vendor={'CompanyA'},Period={'$(=Max(Period)-1)'}>}units))

Regards

Aviral