topic count - formula in QlikView

count - formula

Wed, 03 Aug 2011 08:36:06 GMT

Hi guys!

I need one help...

I have this Formula: Count(distinct SalesOrderID)/Count(distinct total <DayTimeShiping> SalesOrderID)

it's working correct, but I have to set up with a date, that means: my result should show with the current date of 30-June-2009, I have also on my Script: LET vTodayDate = num(MakeDate(2009,06,30)); //Today's Date

How can I put the Date in my formula? Have someone an idea?

Regards

Jenni

count - formula

SunilChauhan — Wed, 03 Aug 2011 08:41:51 GMT

u can write like this

Count( if(Datefiled=$(vTodaydate),SalesOrderid)/count(distinct total <dateTimeshipping>if(datefield=$(VToDayDate)salesorderid)

thanks

Sunil Chauhan

count - formula

Wed, 03 Aug 2011 08:54:30 GMT

Thanks Sunil!

count - formula

Wed, 03 Aug 2011 09:01:38 GMT

it's not working

I have this:

Count(if(Year=$(vCurrentYear),SalesOrderID)/Count(distinct total(if(Year=$(vCurrentYear),<DayTimeShiping>SalesOrderID))

count - formula

SunilChauhan — Wed, 03 Aug 2011 09:03:11 GMT

can u share sample

count - formula

Wed, 03 Aug 2011 15:42:38 GMT

This is formula working, but it just show the current year of 2009,

Count({$<FinYear={$(=Max(FinYear))}>}distinct SalesOrderID)/Count({$<FinYear={$(=Max(FinYear))}>}distinct total <DayTimeShiping> SalesOrderID)

but with full Date--> Month(June), Year(2009) and Day(30), I cant do it with the Variable "vTodayDate"

I put a sample....