topic Re: Counting back from a selected date in QlikView

Counting back from a selected date

Wed, 25 Nov 2020 16:16:04 GMT

Hello!

I need to create ''count'' the number of dates there since I select date (including this) backwards. I tried with ''GetTheFieldSelection'' and put it in a script with SET, but I could not.

The program did not recognize it as a function I believe, and I am new in Qlik

Other ways I tried is this, that only works if I'm not selecting anything. When I make a selection, the result always gives the same.

count ({<FechaDeBaja = { "<= $ (max (date (FechaDeBaja)))"}>} FechaBaja)

Thank you very much!

Re: Counting back from a selected date

sunny_talwar — Fri, 28 Oct 2016 18:13:42 GMT

May be this:

Count({<FechaDeBaja = {"<=$ (=Date(Max(FechaDeBaja)))"}>} FechaBaja)

Re: Counting back from a selected date

sunny_talwar — Fri, 28 Oct 2016 18:15:41 GMT

or this if you date format for FechaDeBaja is not what have in your environmental variable:

Count({<FechaDeBaja = {"<=$ (=Date(Max(FechaDeBaja), 'DateFieldFormatHere'))"}>} FechaBaja)

Here replace DateFieldFormatHere with your date field format for FechaDeBaja. Also, look here:

Dates in Set Analysis

Re: Counting back from a selected date

Fri, 28 Oct 2016 18:25:27 GMT

When I use this function:

Count({<FechaDeBaja = {"<=$ (=Date(Max(FechaDeBaja)))"}>} FechaBaja)

All the results are 0.

Counting back from a selected date

Re: Counting back from a selected date

sunny_talwar — Fri, 28 Oct 2016 18:40:28 GMT

What format is FechaDeBaja?

Re: Counting back from a selected date

Fri, 28 Oct 2016 18:48:16 GMT

Is 28/10/2016

Re: Counting back from a selected date

sunny_talwar — Fri, 28 Oct 2016 18:56:34 GMT

Give this a try:

Count({<FechaDeBaja = {"<=$ (=Date(Max(FechaDeBaja), 'DD/MM/YYYY'))"}>} FechaBaja)

Re: Counting back from a selected date

Fri, 28 Oct 2016 19:07:04 GMT

No, it doesn't work.

All the results are 0

Re: Counting back from a selected date

johnw — Fri, 28 Oct 2016 19:07:19 GMT

If no dates are skipped and you mean the number of dates in your entire data set backwards.

max(FechaDeBaja) - min({1} FechaDeBaja) + 1

Though I'm unclear if you're trying to use one field or two - FechaDeBaja and FechaBaja. If two, I'm confused. If one, you'd need to fix all suggested expressions to just use the one.

Re: Counting back from a selected date

Fri, 28 Oct 2016 19:24:17 GMT

Its just one expression ''FechaBaja''

But this function doesn't work .

I don't know how i can do the Set Analysis or the conditional

Re: Counting back from a selected date

johnw — Fri, 28 Oct 2016 21:06:32 GMT

When you say "doesn't work", what do you mean?

Could you give us some example data and expected result for a selection? If everything we suggest is returning 0, or "doesn't work", I suspect your data doesn't look like we are imagining it looks.

For example, I'm imagining a table like this:

FechaBaja Some Other Fields
28/10/2016 blah blah blah
28/10/2016 blah blah something
29/10/2016 blah blah blah
30/10/2016 blah blah blah
31/10/2016 blah blah blah

Now let's say we select 2016-10-31. I would expect my expression (with the field name corrected) to work like this:

max(FechaBaja) - min({1} FechaBaja) + 1
= 2016-10-30 - 2016-10-28 + 1
= 3

That's my understanding of what you're asking for, that you would want 3 returned for this case. Or we can look at Sunny's expression.

Count({<FechaBaja = {"<=$ (=Date(Max(FechaBaja), 'DD/MM/YYYY'))"}>} FechaBaja)
= Count({<FechaBaja = {"<=30/10/2016"}>} FechaBaja)
= count 28/10/2016 and 28/10/2016 and 29/10/2016 and 30/10/2016
= 4

I don't think you want 4, but that's fixed by adding a "distinct", and then it would be 3. But you say you got 0.

So I suspect your data doesn't look like my example above.

Re: Counting back from a selected date

Mon, 31 Oct 2016 07:28:59 GMT

Hi,Can you share the sample application to demonstrate your issue?

Re: Counting back from a selected date

jvitantonio — Tue, 01 Nov 2016 18:15:11 GMT

Florencia, you started the same post three times GedtTheField selection? Contar de la fecha seleccionada hacia atras

GedtTheField selection? Contar de la fecha seleccionada hacia atras

set analysis y getfieldselections

For respect to those who are helping you, could you please keep only one post open and close the others?

Thanks,

Juan