Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator 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
sunny_talwar

May be using if statement

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

View solution in original post

3 Replies
sunny_talwar

May be using if statement

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

sunny_talwar

Or this

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

swuehl
MVP
MVP

Or maybe just using the p() function:

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