topic Re: Set analysis - Date Ranges in QlikView

Set analysis - Date Ranges

Anonymous — Mon, 16 Jul 2018 17:27:10 GMT

Hello,

I am looking to create a table that will include accounts opened starting at specified date and including all accounts opened after that (to the current period).

Currently the user would select a range of the field [OpenDate] to include and the following set analysis provides the counts of accounts.

=Num(count(DISTINCT{<[SalesManager]={'Jon Doe'}>} [Account Number]),'#,##0')

I would like to have the user only need to select the first date and by default all other would be include - for example instead of selecting every date from 12/13/2012 to current - they would only select 12/13/2012 and by default any account opened after than until the current period would be included.

Re: Set analysis - Date Ranges

sunny_talwar — Mon, 16 Jul 2018 17:30:14 GMT

May be like this

=Num(count(DISTINCT{<[SalesManager] = {'Jon Doe'}, OpenDate = {"$(='>=' & Date(Min(OpenDate), 'MM/DD/YYYY'))"}>} [Account Number]), '#,##0')

Re: Set analysis - Date Ranges

Anonymous — Mon, 16 Jul 2018 20:31:25 GMT

Thank you for the quick response. I was able to get the following to work where VStartDate = the [Open Date]:

[Open Date] = {'>=$(vStartDate)'}