topic Re: Expression not calculating correctly in QlikView

Expression not calculating correctly

Fri, 07 Sep 2012 15:36:32 GMT

Hi guys,

I have a field 'Date' which can have various result codes. I want to count the number of contacts in the last month. My expression is:

sum(if(Date>=$(vMonthBack),if(Result='SMC',1,0),0))

However, this gives me the sum of ALL results, not just SMC, so long as there is one SMC in the last month. i.e. if the last month's result codes are:

SOE, SNC, SMC, SLS, SLM, SNC, the expression returns "5" but if the last month's result codes are

SOE, SNC, SLM, SLM, SNC, SNC the expression returns "0".

What am I missing here?

Re: Expression not calculating correctly

RedSky001 — Fri, 07 Sep 2012 15:52:32 GMT

This is quite difficult to follow without seeing your actual data. Can you attach a qvw with sample data?

I'm pretty sure this would get you more responses.

Mark

Re: Expression not calculating correctly

whiteline — Sat, 08 Sep 2012 14:53:42 GMT

It seems that you have 5 rows for 'SMC' so count returns 5.

Add a tablebox and look at your data.