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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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 II
Partner - Master II

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?