Lottery 7/39

[qlikserbian]

Hi everyone,

i am new one here and in qv.. Lot interesting things i have seen here thanks to this community blog..

I am have question about lottery 7/39, how to check all combination and make conclusions which number show up the most and etc.

For example, If I have my lucky seven numbers 1,2,3,4,5,6,7 and all combination happened over year (in attach) on lottery 7/39 numbers I want to:
the first: make qv file (how to make this excel table appropriate to load in qlikview?

the second: how to make filter with numbers 1-39 when I select number 1 to show me all combination from lottery?

could anyone sent example of qlv files with solution.

In that way is the best learning.

Probably I have two tables connected some how. For sure this question is easy, but I have no idea how to do that.

Thanks in advance,

[preminqlik]

can you please post sample output file so that i can get u...

according to my understanding ...u can use to seperate

subfield(Numbers,' ',1)               as          numberA,

subfield(Numbers,' ',2)               as          numberB,

etc

etc

[rbecher · Accepted solution]

Hi Boriša,

you can load the lottery drawings like this:

LotteryDrawing:
LOAD DrawNo, If(Mod(RowNo(),7)=0, 7, Mod(RowNo(),7)) as Position, Subfield(Numbers, ' ') as Number;
LOAD [#of game in 2013] as DrawNo, 
     Numbers
FROM

(ooxml, embedded labels, table is [lottery combination]);

It will create a table with one record per number and drawing. Please take a look into the attached QVW for analysis.

- Ralf

[swuehl]

Maybe like this?

[qlikserbian]

Great Swuehl, really great..thank you. This is great solution.

[qlikserbian]

Great Ralf, really great..thank you. This is great solution as well.

[qlikserbian]

Swuehl,

i need help. Could you help me. I have problem