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

Add Up count values

Hi,

i want to add up count values. I try it like this, but it doesn´t work:

Count({<[prodYear] = {"$(=getfieldselections(Year))"},[prodMonth] = {"Nov"}>}products) + Count({<[prodYear] = {"$(=getfieldselections(Year))"},prodMonth = {"Okt"}>}products)

The dimension in this chart is prodMonth.

My target is to add up allways the number of products for the last three month.

In Sep i want the sum of products for Jul, Aug, Sep

In Okt i want the sum of products for  Aug, Sep, Okt

etc.

How can i do it?

regards,

sam

10 Replies
sunny_talwar

Because the way this is structured, you probably won't be able to do a distinct count here. I think, to handle this, you would need to use The As-Of Table‌ because this approach will be the easiest in handling any issues that you are having regarding a distinct counting