topic Calculation between two count values of different fields in QlikView

Calculation between two count values of different fields

Mon, 28 Jun 2010 22:38:09 GMT

Hello community,

I have two statistics boxes, both of them with a value representing the count of a field; let's call these values val1 and val2.

I need to have another value: val3 = val1/val2. Can I have this calculation made somehow, specifying it with some object? Or do I need to make this calculation in my load script and in the database?

Thanks in advance,

Regards,

Ygor

Calculation between two count values of different fields

johnw — Mon, 28 Jun 2010 22:46:09 GMT

I assume it's something as simple as making a text box with this expression:

=count(field1)/count(field2)

Or if you want distinct values:

=count(distinct field1)/count(distinct field2)

But I may be misunderstanding the question.

Calculation between two count values of different fields

Mon, 28 Jun 2010 22:52:43 GMT

Actually, it really is as simple as that!

I thought the text box was just a simple object to add text, I should have explored it further before making silly questions 🙂

Thank you very much for the quick reply!

Regards,

Ygor