Solved: Re: ytd formula picking up ytd results - Qlik Community

Anonymous · ‎2016-09-29

Hi,

I have the following formula that is not picking up the Financial Year Total results. I know its in the syntax but cant see it. where am I wrong please:-

Let vCurrentfYear = 2017;

If(Contact <> '', Count({'$Year={vCurrentfYear'} Type))

Cheers,

Laura

sushil353 · ‎2016-09-29

if you are using variable .. then in that case the value will change according to the selection.

I hope you have create the variable some thing like =Max(MonthYear)

View solution in original post

sushil353 · ‎2016-09-29

Hi Laura,

Try this: Count({<Year={'$(vCurrentfYear)'},Contact -={""}>} Type)

HTH

Sushil

Anonymous · ‎2016-09-29

What Sushil shared, should work.

You can see this as well for better understanding?

Set Analysis for certain Point in Time

Set Analysis for Rolling Periods

Anonymous · ‎2016-09-29

Hi Sushil,

I am getting a red error under the first squiggle bracket:-

-={" "}>} Type))

Anonymous · ‎2016-09-29

thank-you!!!

sushil353 · ‎2016-09-29

It will be ok.. as this -= is not recognized by qv.

Anonymous · ‎2016-09-29

the only thing I don't like about the coding is the hard coded periods though

Anonymous · ‎2016-09-29

but it returns '0' in results

Anil_Babu_Samineni · ‎2016-09-29

How about this

Aggr(Count({<Year={'$(vCurrentfYear)'}>} Type), -Contact)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

sushil353 · ‎2016-09-29

Try with this one

If(not isnull(Contact),Count({<Year={'$(vCurrentfYear)'}>} Type))