Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mikeslade
Contributor III
Contributor III

Set Analysis GetFieldSelections with date problem

Afternoon all  

Need a little guidance to get this working, being trawling questions and can't get this to work.  I'd like to use getfieldselections in the calculation.

This works:

Count({<WeekEnding ={'05/08/2018'}>}distinct ID)

I want to replace '05/08/2018' to work off a filter pane of a field called StartDate

Something like this:

Count({<WeekEnding ={date#(GetFieldSelections('StartDate'),'DD/MM/YYYY')}>}distinct ID)

Anyone able to help?

Thanks in advance.

1 Solution

Accepted Solutions
sunny_talwar

Try this

Count({<WeekEnding ={"$(=Date(Max([StartDate]), 'DD/MM/YYYY'))"}>} DISTINCT ID)

View solution in original post

2 Replies
sunny_talwar

Try this

Count({<WeekEnding ={"$(=Date(Max([StartDate]), 'DD/MM/YYYY'))"}>} DISTINCT ID)

View solution in original post

mikeslade
Contributor III
Contributor III
Author

Thank you! Apologies for the delay in response!