topic Re: if condition between two time stamps in QlikView

if condition between two time stamps

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

i need to do an if condition between two times

Accesstime, Clearingtime. these are not in the timestamp format.

My condition is if (Accesstime - Clearingtime) is less than 30 minutes, then count the distinct salesproducts by year.

i m trying the below expression

IF(Time(Accesstime ,'hh:mm:ss')-Time(Clearingtime,'hh:mm:ss') <=('00:30:00'),

count(DISTINCT ProductNumber))

This expression is working fine if my dimension is ProductNumber.

but i want to calculate this by year, by month,.. it is not working with my calendar dimensions

Please help me to correct my expression

sunny_talwar — Mon, 10 Oct 2016 14:59:57 GMT

You can try this:

Count(DISTINCT If(Time(Accesstime ,'hh:mm:ss')-Time(Clearingtime,'hh:mm:ss') <=('00:30:00'), ProductNumber))

Anil_Babu_Samineni — Mon, 10 Oct 2016 15:00:43 GMT

Try this too

IF(Time(Interval(Accesstime - Clearingtime),'hh:mm:ss') <=('00:30:00'),

count(DISTINCT ProductNumber))

Mon, 10 Oct 2016 15:32:10 GMT

thank you so much sunny