topic Re: Set analysis date issue in QlikView

Set analysis date issue

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

hey all i have a field Of this form "last interaction date"(6/1/2016,....) my question is:

the data set contain list of client ids with their last interaction date:

i need to show a list of clients that are not contact the last six month

how can i write in the set analysis?

Hope you can help.

thanks you

MK_QSL — Wed, 29 Jun 2016 08:28:39 GMT

Provide some sample data to work.

jonathandienst — Wed, 29 Jun 2016 08:30:35 GMT

Something like:

Concat({<[last interaction date] = {"<=$(=AddMonths(Today(1), -6))"}>} distinct ClientName, ', ')

to display in a list box. Replace ClientName with the correct field name.

jonathandienst — Wed, 29 Jun 2016 08:32:20 GMT

Or for a calculated dimension:

=Aggr(Only({<[last interaction date] = {"<=$(=AddMonths(Today(1), -6))"}>} ClientName), ClientName)