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: 
newbie_sm
Contributor III
Contributor III

How to set wildcard expressions and set analysis with 2 dimensions?

    Product
Years Month "A" "B"
2022 Jan   29000
  Feb   29000
  Mar   29000
  Apr   29000
2023 Jan 50600 10000
  Feb 51600 10000
  Mar 56000 10000
  Apr 53500 10000
Labels (3)
2 Replies
BrunPierre
Partner - Master
Partner - Master

Hi, can you elaborate?

newbie_sm
Contributor III
Contributor III
Author

I need a wildcard formula to calculate aggregate sum sales where 

For Product B, in months Jan-Apr 2022, the value should calculate as 29000 and in Jan-Apr 2023 is 10000

while for Product A, the values are different from each month.

How do I sum these together?