topic Multiply all combinations of a dimension in QlikView

Multiply all combinations of a dimension

Anonymous — Fri, 20 Nov 2015 13:23:41 GMT

Hi!

I have a dataset that looks like this:

CustomerID	Fruit	Sales
1	Apple	5
1	Banana	3
1	Orange	2

And I would like to be able to multiply all combination of fruits for a customer, so that the result would be:

CustomerID	Fruit	Sales
1	Apple	5
1	Banana	3
1	AppleBanana	8
1	AppleBananaOrange	10
1	AppleOrange	7

The reason for this is that I would like to be able to filter on customers who have bought for example more than 3 Apple and Bananas combined.

Is this possible in any way? To loop through the fruit dimension or something? Other suggestions for my dilemma?

Thanks in advance!

Re: Multiply all combinations of a dimension

marcus_sommer — Fri, 20 Nov 2015 14:18:28 GMT

To create this within the script could be very expensive especially by larger datasets. Therefore I suggest to check if you couldn't use the AND mode:

AND and OR

AND-Mode

- Marcus

Re: Multiply all combinations of a dimension

Fri, 20 Nov 2015 15:31:04 GMT

If you need combinations for selections & in the chart dimensions you need to create in script level only. Otherwise you can try on UI with options.

In the script level its Little complicated but it doable. I am little busy today so I will make script whenever I get a chance.