topic Re: Compare values between dates in QlikView

Compare values between dates

Tue, 16 Dec 2014 14:04:34 GMT

Hello all,

I'm trying to compare values between two dates (for example today and yesterday)

I have a field called 'datelog' and I want to count something in my datas (when the field 'erreurs' is 1) for yesterday for example.

I have used the following set analysis :

=count({<erreur={'1'}, datelog={'$(=Date(today()-1))'}>} erreur)

but it still returning "0"

The set analysis for counting is OK and returns the good results

=count({<erreur={'1'}>} erreur

Any help ?

Thank you.

yduval75 — Tue, 16 Dec 2014 14:07:52 GMT

Can you check if datelog field and Date(today()-1)) have the same date format ?

anbu1984 — Tue, 16 Dec 2014 14:08:55 GMT

Check if date format of datelog matches with result of Date(today()-1).

If not matching then add format explicitly in Date(today()-1,'DD/MM/YYY')

Tue, 16 Dec 2014 14:16:06 GMT

or, in your set analysis, where you have "Date(today()-1)", replace it with:

makedate(year(today()-1),month(today()-1),day(today()-1))

Dates and set analysis are a pain in the ... .

Greetz,

Yves

Tue, 16 Dec 2014 15:02:48 GMT

Guys.. thanks for all...

datelog was MM/DD/YYYY as the overall date format for my document was DD/MM/YYYY (and thus for the Date function)..

yduval75 — Tue, 16 Dec 2014 15:03:55 GMT

Ok, can you close your question awith an answer as correct ?

Have a good day