Date

[Anonymous]

Hello,

I use qliksense, I have a variable that retrieves the date of the day.
I wanted to retrieve all id sales before that day.
My set analysis does not work.
The problem does not come from the variable because I can display it, can someone help me with the set analysis?

count ({<claris_dt_resiliation_porter = {"$ (> = $ (vaDate))"}>} id)

[YoussefBelloum]

Hi,

try to attach sample data

[mdmukramali]

Hi,

Can you try below Expression.

count ({<claris_dt_resiliation_porter = {"<=$(=vaDate)"}>} id)

if it's not helpful then can you share sample application.

Thanks,

Mukram

[Anonymous]

This it's ok

claris_dt_resiliation_porteur = {"<=$(vaDate1)"} >}id)

Thank u.

Have a good weekend!

[cgxanth21]

Hello,

Try this :

count({<[claris_dt_resiliation_porter] = {'<= $(vaDate)'}>} id)

If I understood correctly you want all sales IDs before that date.

[Anonymous]

Yours works
but that  claris_dt_resiliation_porter = {"<= $ (vaDate 1)"} also worked

[cgxanth21]

I had not seen other replies when I commented !

Happy to help though!

Have a nice weekend!

[Anonymous]

thanks.

You too have a great weekend!