topic Re: Counting Dateformats in QlikView

Counting Dateformats

Wed, 05 Nov 2014 09:05:09 GMT

Hi all,

I have a question I hope someone would be able to help me with. I have a column which displays date in varying formats: some are 'DDMMYYYY', some are 'MMDDYYY', some 'YYYYMMDD' and so on and so forth. Is there perhaps a command that would count all the distinct date formats and then report a count for each? I suppose something along the lines of Count(if(.....) as expression and Count distinct as dimensions in a chart, but I can't figure out a precise format.

Thank you all so much!

Re: Counting Dateformats

ashfaq_haseeb — Wed, 05 Nov 2014 09:22:07 GMT

Hi,

You need to look at Alt() function

alt(date#(DateString, 'YYYY-MM-DD'), date#(DateString, 'DD-MM-YYYY'), date#(DateString, 'DD/MM/YYYY'), 'No Date Found') AS Date

Replace it with your required format.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/25/which-conditional-functions-do-you-use

Regards

ASHFAQ

Re: Counting Dateformats

Wed, 05 Nov 2014 09:27:30 GMT

Thank you so much! You've been very helpful!

Re: Counting Dateformats

ashfaq_haseeb — Wed, 05 Nov 2014 09:29:45 GMT

Welcome