topic Set Analysis with Variables in QlikView

Set Analysis with Variables

Wed, 27 Nov 2013 08:35:03 GMT

I am trying to convert this expression into set analysis.

here vFromDate and vToDate are variables

Can anyone help me in forming the expression for the same in set analysis

kaushiknsolanki — Wed, 27 Nov 2013 08:38:44 GMT

Hi,

Try this.

Count({<ACTIVE = {"1"},GOAL_CREATED_DT = {">=$(vFromDate)<=$(vToDate)"}>}GOAL_MEM_RMK)

Regards,

Kaushik Solanki

MayilVahanan — Wed, 27 Nov 2013 09:56:13 GMT

Try like this

Count({<ACTIVE = {"1"},GOAL_CREATED_DT = {">=$(Date(vFromDate))<=$(Date(vToDate))"}>}GOAL_MEM_RMK)