topic Re: count matching values in a collumn in QlikView

count matching values in a collumn

Mon, 08 Aug 2016 19:37:05 GMT

Count((MsgType)=(census)) as you know this does not work.

My field has 5 different values I am creating a table to display Facility month year and Census, Newrx, and three other.

How do I count only one of the five in each column?

trdandamudi — Mon, 08 Aug 2016 19:40:52 GMT

It should be as below:

Count( {<MsgType={'census'}>} census)

Count( {<MsgType={'Newrx'}>} Newrx)

Mon, 08 Aug 2016 19:51:01 GMT

This is what I have but it only counts 1

Count( {<MsgType={'NEWRX'}>} 'NEWRX')

trdandamudi — Mon, 08 Aug 2016 19:53:36 GMT

I don't have any data to tell you what is wrong... Can you please upload a sample app with expected output so that we can take a look.

Note: You have extra quotes at the end, so remove them. It should be as below:

Count( {<MsgType={'NEWRX'}>} FieldName)

vishsaggi — Mon, 08 Aug 2016 19:58:01 GMT

Try this:

Without quotes for the field name and is your field name all capitals or like this Newrx ?

Count( {< MsgType = { 'NEWRX' } >} Newrx)

sunny_talwar — Mon, 08 Aug 2016 20:09:36 GMT

How about this:

Count({<MsgType={'NEWRX'}>} MsgType)

Anonymous — Mon, 08 Aug 2016 20:17:37 GMT

Send a qvw example

vishsaggi — Mon, 08 Aug 2016 20:21:51 GMT

My bad, Thanks for catching this Sunny.

RObert please use sunny's expression. It should work.

Mon, 08 Aug 2016 20:32:18 GMT

sunny_talwar — Mon, 08 Aug 2016 20:34:53 GMT

Did you try this?

Count({<MsgType={'NEWRX'}>} MsgType)