How to write expression based on condition?

[#1]

Hi,

I have to write an expression in pivot table.

Dimension1: Label

Dimension2: Topper

Expression: Count(ID)

but the expression should need the condition as

If Label='Poppy' and Topper equal to any other value instead of Topper<>'Poppy' then the expression should show count(Id). how can I write the expression.

can anyone suggest me please.

Thanks.

[Clever_Anjos]

count(if(Label='Poppy' and Topper <> 'Poppy',Id)

[Gysbert_Wassenaar · Accepted solution]

count({< Label = {'Poppy'},Topper -= {'Poppy'} >}ID)

[#4]

count({$< Label = {'Poppy'},Topper -= {'Poppy'} >}ID)

[sarvjeet]

You can achieve this in front end using expression:

count({< Label = {'Poppy'},Topper -= {'Poppy'} >} ID)

Or

you can handle this  in back end. Create another field in datamodel: Col1  with definition

if(Label='Poppy' and Topper <> 'Poppy',1,0)

In UI use expression Sum(Col1)

Aggregation is faster as compare to count with set analysis

-Sarvjeet

[#6]

Thanks.

I have a condition  where Label='ert','tyu','iop','pou','rew','ion','Tr' and Topper ='Divi','patch','Copy','po' then the expression should show count(Id).  will below expression work for it?

Dimension1: Label

Dimension2: Topper

Expression: Count({<Label={'ert','tyu','iop','pou','rew','ion','Tr'}

,Topper ={'Divi','patch','Copy','po'}>} ID)

[PradeepReddy]

try the below thing

Count({<Label={'Poppy'},Topper ={'*'}-{'Poppy'}>} ID)

[#8]

Thanks.

I have a condition  where Label='ert','tyu','iop','pou','rew','ion','Tr' and Topper ='Divi','patch','Copy','po' then the expression should show count(Id).  will below expression work for it?

Dimension1: Label

Dimension2: Topper

Expression: Count({<Label={'ert','tyu','iop','pou','rew','ion','Tr'}

,Topper ={'Divi','patch','Copy','po'}>} ID)

[PradeepReddy]

IF Your requirement is..

Counting the no.of ID's with Label='ert' 'tyu','iop','pou','rew','ion','Tr'  and  Topper ='Divi','patch','Copy','po'.

then whatever expression your writing is correct.

[#10]

Thanks.