topic Re: Set Analysis - Date Range and Value Greater than in QlikView

Set Analysis - Date Range and Value Greater than

ivandrago — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the attached QlikView Document, there are two tables one table will have All the results the other table is using a set Analysis to exclude results, below is what I want it to exclude...

I want to show CredLim (Credit) greater than or equal to 20

And I also want to exclude EgDates where the EgDate is Greater than or Equal to the Start of the Current Month we are in i.e 01-Aug-2017

Thanks

Re: Set Analysis - Date Range and Value Greater than

Anil_Babu_Samineni — Thu, 17 Aug 2017 08:25:53 GMT

Perhaps this?

1) sum({$<CredLim = {'>=20'},EgDate = {"$(='<' & TimeStamp(Floor(MonthStart(Today())), 'DD/MM/YYYY hh:mm:ss'))"}>}aggr(sum(DISTINCT {$<EgDate = {"$(='<' & TimeStamp(Floor(MonthStart(Today())), 'DD/MM/YYYY hh:mm:ss'))"}>} CredLim), CustNo))

2) sum({$<CredLim = {'>=20'},EgDate = {">= $(=TimeStamp(Floor(MonthStart(Today())), 'DD/MM/YYYY hh:mm:ss')) <TimeStamp(Floor(MonthStart(EgDate)), 'DD/MM/YYYY hh:mm:ss')) "}>}aggr(sum(DISTINCT {$<EgDate = {"$(='<' & TimeStamp(Floor(MonthStart(Today())), 'DD/MM/YYYY hh:mm:ss'))"}>} CredLim), CustNo))

Re: Set Analysis - Date Range and Value Greater than

devarasu07 — Thu, 17 Aug 2017 08:27:11 GMT

sum({$<EgDate = {"$(='>' & TimeStamp(Floor(MonthStart(Today())), 'DD/MM/YYYY hh:mm:ss'))"}>}aggr(sum(DISTINCT {$<EgDate = {"$(='>' & TimeStamp(Floor(MonthStart(Today())), 'DD/MM/YYYY hh:mm:ss'))"},CredLim={">=20"}>} CredLim), CustNo))