Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Ajouter dans l'indicateur un filtre sur l'année en cours
Hello, your question is not very specific, but you want something like this?
sum({<year={"$(=year(today()))"}>} Sales )
Hello, your question is not very specific, but you want something like this?
sum({<year={"$(=year(today()))"}>} Sales )
You can make this with a set analysis.
For exemple :
Sum({<Year={"=year(today())"}>} Amount)
Enjoy your Qlik.
Kind regards,
Théo ATRAGIE.
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
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())
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
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] )
i think something it's wrong with this expression qlik sense say ereur dans l'expression