topic Re: Set Analysis in QlikView

Set Analysis

Tue, 16 Sep 2014 03:33:13 GMT

Hi Folks,

I am trying to get count of policy numbers between two dates using the below expression. I am having issues in getting this to work. Please could some one guide me in the right direction.

Count({<N_YEAR={'2014'},Policy_Start_Date = {">=01-01-2014"},Policy_Start_Date = {"<=30-06-2014"}>} DISTINCT(C_POLY_NUM))

regards

Varghese

Re: Set Analysis

sujeetsingh — Tue, 16 Sep 2014 03:46:54 GMT

Try this

Count({<N_YEAR={'2014'},Policy_Start_Date = {'>=01-01-2014'},Policy_Start_Date = {'<=30-06-2014'}>} DISTINCT(C_POLY_NUM))

Re: Set Analysis

Tue, 16 Sep 2014 03:50:00 GMT

Thanks for the response.

But it still doesn't work.

Re: Set Analysis

MayilVahanan — Tue, 16 Sep 2014 03:52:56 GMT

Try like this

Count({<N_YEAR={'2014'},Policy_Start_Date = {">=01-01-2014 <=30-06-2014"}>} DISTINCT C_POLY_NUM)

Hope your date format is DD-MM-YYYY.