Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
hamza4
Contributor
Contributor

ajouter un filtre

Ajouter dans l'indicateur un filtre sur l'année en cours

Labels (1)
1 Solution

Accepted Solutions
Clement15
Creator III
Creator III

Hello, your question is not very specific, but you want something like this?

sum({<year={"$(=year(today()))"}>} Sales )

View solution in original post

7 Replies
Clement15
Creator III
Creator III

Hello, your question is not very specific, but you want something like this?

sum({<year={"$(=year(today()))"}>} Sales )

theoat
Partner - Creator III
Partner - Creator III

You can make this with a set analysis.
For exemple :

Sum({<Year={"=year(today())"}>} Amount)

 

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

hamza4
Contributor
Contributor
Author

c 'est un peu ca mais j'arrive pas a avoir un résultat l'indicateur affiche toujours 0 je veux extraire l'annee depuis la variable suivante 

 

Clement15
Creator III
Creator III

Do you want the indicator to show the year? If so, you should use this function. And select 'Measure expression' in 'Number formatting'

 

year(today())

 

hamza4
Contributor
Contributor
Author

I want to retrieve the year from the date field 'Date-s' so that I can filter on the mentioned year

i do somthing like : Sum({<Year={"$(Year([Date-s]))"}>} [Montant )] but stille d'ont work 

 

Clement15
Creator III
Creator III

In this case it doesn't work, because the function doesn't work on a field with multiple variables. I don't know if this is suitable but you can use this.

Sum({<Year={"$(Year(max([Date-s])))"}>} [Montant] )

hamza4
Contributor
Contributor
Author

i think something it's wrong with this expression qlik sense say ereur dans l'expression