Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
See if this is what you had in mind.
Hi Niegel,
Check if the attached app suits your needs.
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.
definitely what I was looking for.
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!
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).