Report on Range of Values per Group

[niegel]

I'm wondering if you guys can help me out with setting up this report.

I have a zipcode table that assigns it to a group. What I need is to show the range of each group so I could prepare it for a my script for another program.

E.g.

Zipcode     Group

00001          A

00002          A

00003          A

00004          A

00005          B

00006          B

00007          A

00008          A

00009          B

00010          A

Result will show these:

ZipCode Range     Group

00001 to 00004     A

00005 to 00006     B

00007 to 00008     A

00009                    B

00010                    A

Any chance this is possible in Qlikview?

[#2]

See if this is what you had in mind.

[#3 · Accepted solution]

Hi Niegel,

Check if the attached app suits your needs.

[niegel]

Thanks for this. I got the idea but the sample file did not exactly produced the kind of result I was expecting. The results were overlapping of each other.

[niegel]

definitely what I was looking for.

Niegel

[niegel]

follow-up question on this:

If I wanted to show the list of zip and the range they are associated to, how woudl I do it? I was thinking of doing a mapping or loading the zip before the grouping but it did not turn out quite well.

Zipcode     Group     Range

00001          A          00001 to 00004

00002          A          00001 to 00004

00003          A          00001 to 00004

00004          A          00001 to 00004

00005          B          00005 to 00006

00006          B          00005 to 00006

00007          A          00007 to 00008

00008          A          00007 to 00008

00009          B          00009

00010          A          00010

Thanks!

[#7]

Niegel, check the attached app.

You'll see 2 tabs in the script, uncomment the one you want depending on your desired outcome (in 1 or 2 tables).