topic Re: Problem with frequency in QlikView

Problem with frequency

qw_johan — Wed, 28 Nov 2012 18:44:56 GMT

I have a problem checking for frequency. I need to know how many times a, b & c have been together.

a->b and b->a should both count as being together for a&b. The result I want is:

a&b = 3

b&c = 1

c&a = 2

MyTable:

Thanks,

johan

Wed, 28 Nov 2012 19:14:08 GMT

Create a Straight Table with a Calculated Dimension:

=If(IN < OUT

, IN & ' & ' & OUT

, OUT & ' & ' & IN)

This will ensure that b & a is the same as a & b

Expression is simply Sum(1).

-John

qw_johan — Wed, 28 Nov 2012 20:24:50 GMT

Thanks for your quick reply.

That REALLY worked like I wanted it too. Thanks!

a, b, c ... etc represents ip numbers...but that shouldn't make a difference in the expression?

And I have around 100 000 records in my table...using an "if..." expression still ok?

Thanks again John

Wed, 28 Nov 2012 20:29:16 GMT

You're welcome. It should work with IP addresses just fine.

Whether the calculation is too much with 100,000 records depends on what else you're doing.

But if performance suffesr because of the calculated dimension, move it into the load statement so you can use a regular field in your table.