topic Re: Re: IF into Set Analysis in QlikView

IF into Set Analysis

suzel404 — Sun, 23 Mar 2014 00:57:47 GMT

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 — Sun, 23 Mar 2014 03:34:01 GMT

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 — Sun, 23 Mar 2014 10:12:00 GMT

Hi Chiranjeevi,

Thanks for your response but it doesn't work.

maxgro — Sun, 23 Mar 2014 14:21:52 GMT

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

suzel404 — Sun, 23 Mar 2014 15:33:29 GMT

Massimo,

Sorry for mon qvw. My separator was not correct.

maxgro — Sun, 23 Mar 2014 16:46:12 GMT

hope I understand your question, see attachment

you find a textbox with some explanation in the attachment

suzel404 — Sun, 23 Mar 2014 17:27:04 GMT

Many thanks, Massimo.