topic Re: Set analysis with date in QlikView

Set analysis with date

Wed, 08 Jun 2011 09:39:50 GMT

Hi. I am trying to sum a field from a certain date onwards. This works:

sum(if(KEY_Date>='2011/06/01',NumberRegistered))

The set analysis approach which actually what I want does not work:

sum({$<KEY_Date={">=2011/06/01"}>}NumberRegistered)

Can someone tell me where I am going wrong? Thanks very much.

Re: Set analysis with date

Miguel_Angel_Baeyens — Wed, 08 Jun 2011 09:42:25 GMT

Hi,

The syntax should be

Sum({< KEY_Date = {">=$(=Date('2011/06/01'))"}>}NumberRegistered)

Provided your regional settings in your operating system are set to 'YYYY/MM/DD', otherwise you will need to modify them or make some formatting in the script.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Set analysis with date

Wed, 08 Jun 2011 10:11:28 GMT

Thanks Miguel - works perfectly!