topic Re: Lottery 7/39 in QlikView

Lottery 7/39

qlikserbian — Sat, 04 Jan 2014 19:17:15 GMT

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,

Re: Lottery 7/39

preminqlik — Sat, 04 Jan 2014 19:24:38 GMT

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

Re: Lottery 7/39

rbecher — Sat, 04 Jan 2014 19:49:17 GMT

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

Re: Lottery 7/39

swuehl — Sat, 04 Jan 2014 19:53:58 GMT

Maybe like this?

Re: Lottery 7/39

qlikserbian — Sat, 04 Jan 2014 20:22:45 GMT

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

Re: Lottery 7/39

qlikserbian — Sat, 04 Jan 2014 20:23:15 GMT

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

Re: Lottery 7/39

qlikserbian — Tue, 18 Feb 2014 21:32:32 GMT

Swuehl,

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