topic simple count function in QlikView

simple count function

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

Hi Experts,

Can any one please help me on this.

Under DOB field I have entries like

DOB

1991-05-12

2002-01-29

1985-06-30

2011/19/01

02/05/2015

I have to count the DOB where is not in the YYYY-MM-DD format.

Example

2011/19/01

02/05/2015 is in different format so the count is 2.

Thanks in advance.

Anil_Babu_Samineni — Thu, 07 Dec 2017 12:04:43 GMT

May be create flag like?

If(Date(DOB, 'YYYY-MM-DD'), 1,0) as Flag

And expression is

Count({<Flag = {0}>} Date)

sunny_talwar — Thu, 07 Dec 2017 12:08:05 GMT

May be this

If(IsNum(Num(Date#(DOB, 'YYYY/DD/MM'))), 1,

If(IsNum(Num(Date#(DOB, 'DD/MM/YYYY'))), 2)) as DOBFormatFlag

and then just do Count(DISTINCT DOBFormatFlag)