Set Analysis - Date Range and Value Greater than

[ivandrago]

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

[Anil_Babu_Samineni · Accepted solution]

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))

[devarasu07]

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))