topic Re: Date in App Development

Date

Anonymous — Fri, 17 Nov 2017 15:59:31 GMT

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)

Re: Date

YoussefBelloum — Fri, 17 Nov 2017 16:10:27 GMT

Hi,

try to attach sample data

Re: Date

mdmukramali — Fri, 17 Nov 2017 16:16:33 GMT

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

Re: Date

Anonymous — Fri, 17 Nov 2017 16:35:11 GMT

This it's ok

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

Thank u.

Have a good weekend!

Re: Date

cgxanth21 — Fri, 17 Nov 2017 16:38:54 GMT

Hello,

Try this :

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

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

Re: Date

Anonymous — Fri, 17 Nov 2017 16:48:17 GMT

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

Re: Date

cgxanth21 — Fri, 17 Nov 2017 16:52:38 GMT

I had not seen other replies when I commented !

Happy to help though!

Have a nice weekend!

Re: Date

Anonymous — Fri, 17 Nov 2017 17:01:08 GMT

thanks.

You too have a great weekend!