Count something but only for one particular field

[#1]

Hi there,

I need some code:

I'm counting all the rows, in my QV it's the column "dossiernummer" and from that column

I only want to select/get particular one (called "Almere").

Can you help me how to get specific data from a column?

I don't want to use a select box, should be a set chart for that particular "almere".

hope to hear you, thanks in advance,

Tim Visser

[tresesco · Accepted solution]

May be like:

=Count({<dossiernummer={'Almere'}>} dossiernummer)

Note: 'Almere' and 'almere' are not same; you have to mention right one.

[israrkhan]

what do you want count, sum, avg or ???

let say dossiernummer is a field name in a table and Almere is value in the field.

use =sum({<dossiernummer={'Almere'}>} Value)

=count({<dossiernummer={'Almere'}>} Value)

[#4]

Hi,

it seems that you want to use set Analysis. See a document I wrote on the subject :

http://community.qlik.com/docs/DOC-4951

Certainly, your expression would be:

sum({<dossiernumber ={"Almere"} >} YourData)

Take care that QV is case sensitive.

Fabrice