Discussion board where members can get started with QlikView.
I have this raw data in qlikview having multiple ReportIds & each Id having ReportDates. I need to show a pivot displaying count of ReportId's having maximum ReportDate only for that particular report.
create a table
reportId as dimension
count(distinct ReportDate) as expression
I don't think this would work... because ReportId = 1 has only 3 distinct dates
Similarly, ReportId = 4 has only 2 distinct dates....
Not sure I understand the logic... can you please elaborate pooja_sn
Looking for below solution
in back end modify your script like
Load ReportId,date(Date#(ReportDate,'DD/MM/YYYY')) as ReportDate INLINE [
Load ReportId,Date(max(ReportDate)) as maxDate Resident Test Group by ReportId;
Load ReportId,maxDate,ReportDate,if(ReportDate=maxDate,1,0) as flag Resident Test;
drop table Test;
In front end take straight table
dimension : ReportId
May be try
Load * Inline
Max(ReportDate) as ReportDate,
1 as MaxReportDate
in the front end, user reportid as dimension