Can QlikView generate all possible combinations of values?

[Anonymous]

I know it's a vague title, sorry.

I have multiple product types that have different dollar values.  I am trying to generate a table that will have all the combinations of values. 

Example:

Rate Plan - 4, 15

Text Pack - 3, 6, 12

Data - 15, 25

Addl Features - 3, 6 , 9

Trying to build all combinations as:

1.   Rate 4

2.   Rate 4, Text 3

3.   Rate 4, Text 3, Data 15

4.   Rate 4, Text 3, Data 15, Addl Feat 3

and on and on. 

Can anyone think of a way do this?

Thanks

[Gysbert_Wassenaar · Accepted solution]

You can create a cartesian product from all these fields:

CartesianProducts:

load * inline [

Rate Plan

4

15

''];

join load * inline [

Text Pack

3

6

12

''];

join load * inline [

Data

15

25

''];

join load * inline [

Addl Features

3

6

9

''];