# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Contributor II

## Return a full set of dates when no selection is made in set analysis

Hi,

In the formula below, I have to make a selection to make it work, what I would like is when there is no selection in Master Month Date for the formula to return the full list of dates, then when dates are selected, just returns those dates.

Thanks.

count(DISTINCT {\$<[MonthLogged_Open_Balance]=[Master Month Date],[Related_Open_Balance]={'YES'}>} %KEY_CaseIDR5_Open_Balance)

1 Solution

Accepted Solutions
MVP

## Re: Return a full set of dates when no selection is made in set analysis

May be using if statement

Count(DISTINCT {\$<[Related_Open_Balance]={'YES'}>} If([MonthLogged_Open_Balance] = [Master Month Date], %KEY_CaseIDR5_Open_Balance))

3 Replies
MVP

## Re: Return a full set of dates when no selection is made in set analysis

May be using if statement

Count(DISTINCT {\$<[Related_Open_Balance]={'YES'}>} If([MonthLogged_Open_Balance] = [Master Month Date], %KEY_CaseIDR5_Open_Balance))

MVP

## Re: Return a full set of dates when no selection is made in set analysis

Or this

Count(DISTINCT {\$<%KEY_CaseIDR5_Open_Balance = {"=[MonthLogged_Open_Balance] = [Master Month Date]"}[Related_Open_Balance]={'YES'}>} %KEY_CaseIDR5_Open_Balance)

MVP

## Re: Return a full set of dates when no selection is made in set analysis

Or maybe just using the p() function:

count(DISTINCT {\$<[MonthLogged_Open_Balance]= p( [Master Month Date]) ,[Related_Open_Balance]={'YES'}>} %KEY_CaseIDR5_Open_Balance)

Community Browser