Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jonathan_ineox
New Contributor III

Date

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)

7 Replies
YoussefBelloum
Esteemed Contributor

Re: Date

Hi,

try to attach sample data

mdmukramali
Valued Contributor II

Re: Date

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

jonathan_ineox
New Contributor III

Re: Date

This it's ok

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

Thank u.

Have a good weekend!

cgxanth21
New Contributor II

Re: Date

Hello,

Try this :

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

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

jonathan_ineox
New Contributor III

Re: Date

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

cgxanth21
New Contributor II

Re: Date

I had not seen other replies when I commented !

Happy to help though!

Have a nice weekend!

jonathan_ineox
New Contributor III

Re: Date

thanks.

You too have a great weekend!

Community Browser