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: 
Anonymous
Not applicable

Missing is not supported in array type histogram (Valeur manquante non prise en charge dans tableau type histogramme)

Hello,

I am looking for a way to make a cumulative 12 months without losing information when the latter does not exist on one month.

I try cumulative basis for my expression, but unfortunately when the value does not exist for this month, it is not displayed.

This is annoying because I end up with a table full of holes and does not look like a table of 12 cumulative months.

Do you have an idea ?

Thank you in advance.

Along the same time an example.

Translated with Google Translate - Qlik Community Administrative Team

Bonjour,

Je cherche le moyen de faire un cumule sur 12 mois sans perdre l'information lorsque celle ci n'existe pas sur 1 mois.

J'ai essayer la fonction cumulé pour mon expression, mais malheureusement lorsque que la valeur n'existe pas pour ce mois, elle est pas affiché.

Cela est embêtant, car je me retrouve avec un tableau plein de trou et qui ne ressemble pas à un tableau cumulé sur 12 mois.

Avez vous une idée ?

Merci par avance.

Je joins par la même occasion un exemple.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw. For more information see this document: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See attached qvw. For more information see this document: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Thanks a lot for your help.