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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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