Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

davidoxi
New Contributor III

Calculate the number of rows in a column with condition

Hello,

I have the following expression :

if([Type de commande] = 'URGENT' or  [Type de commande] = 'GROS' or [Type de commande] = 'PVI' ,Aggr( count([N° de commande]),[N° de client]),1)

And I want to calculate the order number for each customer number

And thank you in advance

1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Calculate the number of rows in a column with condition

May be this in your expression:

= Sum(Aggr(Count(if(Match([Type de commande], 'URGENT','GROS', 'PVI'), [N° de commande])),[N° de client]))

3 Replies
MVP
MVP

Re: Calculate the number of rows in a column with condition

Where are you doing this? In a chart with client as dimension or somewhere else?

vishsaggi
Esteemed Contributor III

Re: Calculate the number of rows in a column with condition

May be this in your expression:

= Sum(Aggr(Count(if(Match([Type de commande], 'URGENT','GROS', 'PVI'), [N° de commande])),[N° de client]))

davidoxi
New Contributor III

Re: Calculate the number of rows in a column with condition

thank you Vishwarath Nagaraju The exercise was resolved