Ignore filter

[spividori]

Hi.

My English is poor, I hope you understand me. Sorry. I have the following query:

I make the selection on the "KeyLinkIndAju" field and it shows me that the "Id_art" = 38657 had stock movements on the dates 09/02/2024 and 08/19/2024 in idDep = 101. I need to filter the sales that occurred between those dates, that is, the units sold >= 08/19/2024 and >= 09/02/2024.
I have tried with this expression: Sum ({< Date = {"> = $ ( = min (date (Date))) < = $ ( = max (date (Date)))"}, Date => } Sales) but it takes the sales that occurred only on 08/19 and 09/02.

Regards.

[marksouzacosta]

Hi @spividori,

Something is not clear. If you have the KeyLinkIndAju 38657 selected, you only have the dates 8/19 and 9/2 available. Are you trying to return all the id_art between those two dates but without KeyLinkIndAju 38657 selected? If so, are those dates hard coded or there is a rule to dynamic get them?

Regards,

Mark Costa

[spividori]

Hi @marksouzacosta , thanks for the reply.
I'm trying to recover the sales of that id_art between those dates with KeyLinkIndAju=38657 selected.

Regards.

[marksouzacosta]

Can you please first confirm that you have those records?

You can build a Table chart and add the columns KeyLinkIndAju, id_art, iDep, Fecha and Sales. Only dimensions, no measures. Select KeyLinkIndAju=38657 and send us please a screen shot of the results.

Regards,

Mark Costa

[spividori]

Hi Mark. I'll try to put together a small example in QlikView and upload it.

Regards.