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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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
Partner - Specialist
Partner - Specialist

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
Partner - Specialist
Partner - Specialist

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

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

theoat
Partner - Specialist
Partner - Specialist

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
Partner - Specialist
Partner - Specialist

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
Partner - Specialist
Partner - Specialist

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