topic Problem with an expression...(Calculation) in QlikView

Problem with an expression...(Calculation)

Mon, 13 Sep 2010 20:18:25 GMT

Hi there,

I have a data field labeled "Document Type" with eight different values, each value corresponding with a document type. I need to define an expression that counts the number of two different document types which are in the same field , and then divides them to get a ratio between them.

Any ideas?

Thanks in advance...

Problem with an expression...(Calculation)

johnw — Mon, 13 Sep 2010 20:41:14 GMT

Maybe this?

count({<"Document Type"={'Type A'}>} "Document")
/count({<"Document Type"={'Type B'}>} "Document")

Problem with an expression...(Calculation)

Mon, 13 Sep 2010 20:49:40 GMT

Excelent, it works!

thanks a lot John

Problem with an expression...(Calculation)

Mon, 13 Sep 2010 20:52:10 GMT

count( {< [Document Type] ={'A'} >} value)
/
count( {< [Document Type] = {'A','B'} >} value)

... and...

count( {< [Document Type] ={'B'} >} value)
/
count( {< [Document Type] = {'A','B'} >} value)