topic Re: if-condition in expression in QlikView

if-condition in expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all!

I need some help with conditioning a calculation. I want to know how many distinct articles that have a delivery time greater than 2 days. My delivery time is formatted as “D + hh:mm:ss” and works well in other expressions.

Writing my expression as “if(time >=’2 + 00:00:00’, Count(DISTINCT(article),0)” does not work. It only shows the zero-value. What am I doing wrong?

Thank you!

Re: if-condition in expression

Anonymous — Wed, 23 Nov 2016 10:25:10 GMT

Can you paste some sample data please

Re: if-condition in expression

Anonymous — Wed, 23 Nov 2016 10:35:45 GMT

Articles, time:

a, 2 + 00:00:00

b, 2 + 00:00:00

c, 3 + 00:00:00

b, 2 + 00:00:00

a, 3 + 00:00:00

b, 5 + 00:00:00

a, 1 + 00:00:00

The expression “if(time >=’2 + 00:00:00’, Count(DISTINCT(a),0)” should return "2", since two of the articles "a" have a time >=2, but it returns "0".

Re: if-condition in expression

Anonymous — Wed, 23 Nov 2016 10:42:12 GMT

if(date#(time,'D + HH:MM:SS')>='2 + 00:00:00',count(DISTINCT(Article)),0)

Re: if-condition in expression

MK_QSL — Wed, 23 Nov 2016 10:43:20 GMT

=COUNT((IF(Timestamp#([time:],'D + hh:mm:ss') >= Timestamp#('2 + 00:00:00','D + hh:mm:ss'),Articles)))

Re: if-condition in expression

rubenmarin — Wed, 23 Nov 2016 10:50:12 GMT

Hi Charlotte, another option:

=If(SubField(time, ' + ', 1)>=2, Count(DISTINCT(article),0))

and another one:

1.In the script create the field Days (or similar) like "SubField(time, ' + ', 1) as Days"

2.Then you can use this field in expression:

=If(Days>=2, Count(DISTINCT(article),0))

or maybe it should be:

=Count(DISTINCT {<Days={">=2"}>} article)

Re: if-condition in expression

Anonymous — Wed, 23 Nov 2016 10:51:42 GMT

count(if(date#(time,'D + HH:MM:SS')>='2 + 00:00:00',Articles))