Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis compare dates

Hello

I need to count the days selected until today.

I want to do something like this:

COUNT(DISTINCT {$<Fecha={<today()}>} Fecha)

But it goes wrong.

"Fecha" is a field in data format. If I show this field for today i see 42110,

Could someone tells me how must i do?

Thanks,

Fernando

11 Replies
Anonymous
Not applicable
Author

Hi, Fernando,

I'm glad you've been helpful , one of the advantages of using variables is that you can use in differents expressions,or at least for me they are very useful.

Regards.

Not applicable
Author

Yes Jannet. Really I used a variable (vToday) in this case. But I wanted to learn exactly what I did wrong in the expression

Regards