topic Re: Set analysis compare dates in QlikView

Set analysis compare dates

Thu, 16 Apr 2015 15:24:27 GMT

Hello

I need to count the days selected until today.

I want to do something like this:

COUNT(DISTINCT {$<Fecha={<today()}>} Fecha)

But it goes wrong.

"Fecha" is a field in data format. If I show this field for today i see 42110,

Could someone tells me how must i do?

Thanks,

Fernando

Re: Set analysis compare dates

swuehl — Thu, 16 Apr 2015 15:26:46 GMT

Try a Dollar sign Expansion and search in your set modifier:

COUNT(DISTINCT {$<Fecha={"<$(=num(today()))"}>} Fecha)

Re: Set analysis compare dates

buzzy996 — Thu, 16 Apr 2015 15:42:18 GMT

u can try this,

=networkdays( Fecha,today())

Fecha* should be date field

Re: Set analysis compare dates

Thu, 16 Apr 2015 15:46:00 GMT

Hi swuehl;

This doesn't go well.

No t return the true result 😞

Thanks

Re: Set analysis compare dates

Thu, 16 Apr 2015 15:49:57 GMT

Hi Shiva;

The expression goes well but I need another thing. I need do it in set analysis.

Thanks a lot. I don't knew the networkdays function 🙂

Re: Set analysis compare dates

buzzy996 — Thu, 16 Apr 2015 15:52:26 GMT

it's calculate accurate days in this case,and we can also use in different purpose to exclude holidays in other cases..

Re: Set analysis compare dates

buzzy996 — Thu, 16 Apr 2015 15:57:03 GMT

if ur happy with tht...u can mark as correct

Re: Set analysis compare dates

Thu, 16 Apr 2015 16:03:52 GMT

I need that someone tells me how do the same with the set analysis.

I mark the like button

Re: Set analysis compare dates

Anonymous — Thu, 16 Apr 2015 17:04:05 GMT

Hi, Fernando.

Try this

create two variables

MinDate= min(Fecha)

MaxDate= Today()

Your Expression:

=count({$<Fecha={"<=$(MaxDate)>=$(MinDate)"}>} DISTINCT Fecha)

Re: Set analysis compare dates

Fri, 17 Apr 2015 06:53:39 GMT

Hi Jannet;

I have to learn more about the use of $(...).

The solution you gave me is just what I needed.

Before I wrote here I tried to do this:

COUNT(DISTINCT {$<Fecha={<today()}>} Fecha

The correct expression is:

count({$<Fecha={"<$(=Today())"}>} DISTINCT Fecha)

I know is better to use variables but I wanted understand why didn't goes well the expression

Thanks a lot

Fernando

Re: Set analysis compare dates

Anonymous — Fri, 17 Apr 2015 14:11:51 GMT

Hi, Fernando,

I'm glad you've been helpful , one of the advantages of using variables is that you can use in differents expressions,or at least for me they are very useful.

Regards.

Re: Set analysis compare dates

Fri, 17 Apr 2015 14:17:06 GMT

Yes Jannet. Really I used a variable (vToday) in this case. But I wanted to learn exactly what I did wrong in the expression

Regards