Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Set Analysis with Variables

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
Error.jpg

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

     Try this.

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted

Hi

Try like this

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