Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))
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))