Qlik Community

Qlik Sense App Development

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

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Valued Contributor

Re: YTD Sales of selected persons

Create one more field latest status and use condition like Latest_status='Active' in the dimension. You can use Firstsortedvalue() to get the latest status.

New Contributor III

Re: YTD Sales of selected persons

Adding a new "latest status" field to the data-model is not preferred, is there any other method?