IF into Set Analysis

[suzel404]

Hi all,

How can I transforme IF syntax in Set analysis?

=COUNT(

IF(ARTICLE_ID=10 OR ARTICLE_ID=15

  AND Date(OpeningDate,'DD/MM/YYYY hh:mm:ss')<= Date(ClosingDate,'DD/MM/YYYY hh:mm:ss')+ maketime(vHours2),1,0

)

     )

Thanks for your help.

[chiru_thota]

You can try below.Variable can make code simple.

Variable1 = Date(ClosingDate,'DD/MM/YYYY hh:mm:ss')+ maketime(vHours2),1,0)

Count({<ARTICLE_ID={10,15},Date(OpeningDate,'DD/MM/YYYY hh:mm:ss')={'<=$(=$(Variable1))'}>} 1)

[suzel404]

Hi Chiranjeevi,

Thanks for your response but it doesn't work.

[maxgro]

this is the ARTICLE_ID of your qvw; how can you (and other people too) check if expression works?

[suzel404]

Massimo,

Sorry for mon qvw. My separator was not correct.

[maxgro · Accepted solution]

hope I understand your question, see attachment

you find a textbox with some explanation in the attachment

[suzel404]

Many thanks, Massimo.