Multiple sets in the same expression using set analysis?

nrq — Thu, 09 Nov 2023 20:57:22 GMT

This is my current code which isn't working properly but showcases what I'm trying to do:

sum({<[CustomerType]*={"1"},[Location]*={"United States","Canada"}>} {<[CustomerType]*={"2","3"},[Location]*={"United States","Mexico","India"}>} [Sales])

In other words, I want the sum of Sales to display data for CustomerType 1 only if they're in the United States or Canada as well as CustomerTypes 2 and 3 only if they're in the United States, Mexico, or India. I can't use one single set for this requirement because, for example, it would include India data for CustomerType 1 which I do not want.

Is what I'm trying to do possible? How do I format the code?

Re: Multiple sets in the same expression using set analysis?

Lisa_P — Thu, 09 Nov 2023 23:03:17 GMT

Try this:

sum({<[CustomerType]*={1},[Location]*={[United States],[Canada]}>} + <[CustomerType]*={2,3},[Location]*={[United States],Mexico,India}>} [Sales])

topic Re: Multiple sets in the same expression using set analysis? in QlikView

Multiple sets in the same expression using set analysis?

Re: Multiple sets in the same expression using set analysis?