Count First Occurrences of Value

Micki — Fri, 11 Dec 2020 15:01:42 GMT

Hi folks, below my simple table

Table1.Date	Table2.Field	New Defects	firstsortedvalue(Date,Date])
20200120	New	1	2020-01-20
20200127	New	1	2020-01-27
20200203	New	1	2020-02-03
20200210	New	1	2020-02-10
20200217	New	1	2020-02-17
20200224	New	1	2020-02-24

Please Notice that i have two fields from different table and i need just to count first appearances

What i did:

COUNT({ [FLAG_NEW] = {'New'}, [Date] = {"=firstsortedvalue(floor([Date]), floor([Date]))"} >}DISTINCT [%WorkItem]) //Option 2 count(Aggr( If(FirstSortedValue(Date_FLoor, -Date_FLoor) = Floor_CreatedDate, 1, 0) , [%WorkItem]))

Still doesn't work 😞

Second Option is working but when i select specific bar it's stop working because i used aggr()

Expected result

Table1.Date	Table2.Field	New Defects	firstsortedvalue(Date,Date])
20200120	New	1	2020-01-20
20200127	New		2020-01-27
20200203	New		2020-02-03
20200210	New		2020-02-10
20200217	New		2020-02-17
20200224	New		2020-02-24

Re: Count First Occurrences of Value

Kushal_Chawda — Fri, 11 Dec 2020 15:13:35 GMT

@Micki what is the dimension of Bar? Try adding that Dimension as well in aggr

topic Count First Occurrences of Value in QlikView

Count First Occurrences of Value

Re: Count First Occurrences of Value