Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

count matching values in a collumn

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?

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: count matching values in a collumn

How about this:

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

View solution in original post

9 Replies
Highlighted
trdandamudi
Honored Contributor II

Re: count matching values in a collumn

It should be as below:

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


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

Highlighted
Not applicable

Re: count matching values in a collumn

This is what I have but it only counts 1

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

Highlighted
trdandamudi
Honored Contributor II

Re: count matching values in a collumn

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)

Highlighted
vishsaggi
Esteemed Contributor III

Re: count matching values in a collumn

Try this:

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


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

Highlighted

Re: count matching values in a collumn

How about this:

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

View solution in original post

Highlighted
marcioarruda
Contributor III

Re: count matching values in a collumn

Send a qvw example

Highlighted
vishsaggi
Esteemed Contributor III

Re: count matching values in a collumn

My bad, Thanks for catching this Sunny.

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

Highlighted
Not applicable

Re: count matching values in a collumn

Highlighted

Re: count matching values in a collumn

Did you try this?

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