topic Re: If Formula in QlikView

If Formula

Tue, 16 Feb 2016 13:32:07 GMT

Hi All,

Can someone please tell me what's wrong with the formula stated below. It provides me with the title since I have checked use expression as title but the content is empty nor does it provide me with an error which indicates there's nothing wrong with the expression.

=if (sum({1 <monthofalltime = {$(=vmonthnum-1)}>} TOTAL <d1cust_clientid> $(=filtered_mrv)) = 0 and sum(TOTAL <d1cust_clientid> $(=filtered_mrv)) <> 0, 'new revenue')

Thanks,

Re: If Formula

sunny_talwar — Tue, 16 Feb 2016 14:11:33 GMT

Is new revenue a field here?

May be this:

=If(Sum({1 <monthofalltime = {$(=vmonthnum-1)}>} TOTAL <d1cust_clientid> $(=filtered_mrv)) = 0 and Sum(TOTAL <d1cust_clientid> $(=filtered_mrv)) <> 0, [new revenue])

Re: If Formula

Tue, 16 Feb 2016 14:26:51 GMT

New revenue is not a field at all it is a way to describe if we had a new customer in the month of business. It doesn't work such as =if(A2=B2,"New", "Old") New and Old both her descriptors like was New revenue.

Re: If Formula

Anonymous — Wed, 17 Feb 2016 00:12:03 GMT

Would recommend a sanity check of the 2 sum aggregation code that looks to be making use of variable comparison inside the set expression. A quick observation, it seems else is not handled? what if you add a comma after 'new revenue'

Re: If Formula

sangeethag — Wed, 17 Feb 2016 06:38:13 GMT

May be your set analysis part have mistake. Try this,

Change your exp monthofalltime = {$(=vmonthnum-1)} to monthofalltime = {$(=$(=vmonthnum)-1)}

Re: If Formula

sasikanth — Wed, 17 Feb 2016 07:37:09 GMT

hi,

can you tell us about this "filtered_mrv"

Re: If Formula

Fri, 19 Feb 2016 15:31:28 GMT

Thanks for all of your responses.