topic Re: Count with Set Analysis per Month in QlikView

Count with Set Analysis per Month

Peter_Brunner — Mon, 12 Nov 2012 05:26:04 GMT

Hi Guys,

I am trying to Count number of New Customers Accounts, Per REP per MONTH, .

I am only selecting different MONTHS from List box as the rest is Set analysis.

I am missing something here as I can only can get an aggerated amount of New Customers per REP up to MONTH Selected ?

I have a table with = NewCustDate, Rep, CustomerNo, CustStat

the NewCustDate , Date format =YYYYMMDD and Data Starting from 20120701

My Expression

Count({$<Rep={'HARRY'},CustStat={'20'}>}CustStat)

I have tried this Expression as well but give same results as above

Count ({$<CustomerNo=p({$<Rep={'HARRY}>}CustomerNo)>}Month(NewCustDate)

any help appreciated

regards Peter

jonathandienst — Mon, 12 Nov 2012 07:48:20 GMT

Have you tried this?

Count({$<Rep={'HARRY'},CustStat={'20'}>} Distinct CustomerNo)

Hope that helps

Jonathan

Peter_Brunner — Mon, 12 Nov 2012 08:14:09 GMT

Hi Jonathan,

Thanks for your reply Yes I ahve tried that one and same result it counts YTD not MTD

Peter

somenathroy — Mon, 12 Nov 2012 10:52:01 GMT

Can you pls upload sample qvw application. From which field or calculated dimention are you selecting month?

Regards,

Som

Mon, 12 Nov 2012 11:24:19 GMT

Count({$<Rep={"HARRY"},CustStat={"20"}>} Distinct CustomerNo)

renjithpl — Mon, 12 Nov 2012 12:04:25 GMT

I am not sure, but can use the below lint to get some idea,

Peter_Brunner — Mon, 12 Nov 2012 12:43:57 GMT

Hi Som,

after reading your reply I went through my script again and found an error in my linked table for the Customers month field

I fixed this so "Month" format matches in both tables and now it selects correctly

Thanks for your help Som

And thanks to all for their suggestions and sorry for only giving you guys half a picture

it now works with the my original

Count({$<Rep={'HARRY'},CustStat={'20'}>}CustStat)

regards Peter