topic Re: Date If Condition in QlikView

Date If Condition

Tue, 09 Sep 2014 09:09:19 GMT

Dear all,

I have used the following expression for the calculation. Kindly go through the attached file.

Sum(if(Date(SALEDATE,'DD/MM/YYYY')=Date(UPDATE,'DD/MM/YYYY'),RATE))

I am not getting the result because SALEDATE is a normal Date Field and UPDATE field format is (DD/MM/YYYY hh:mm:ss), from this field i have taken Date alone for the above expression.

And another condition for the above expression is if the Updatetime is < 12PM it should be AM Rate and if it is >12 PM it should be PM Rate.

Waiting for the reply.

Regards,

Sivasu

Re: Date If Condition

MK_QSL — Tue, 09 Sep 2014 09:29:44 GMT

Load your table as below

DATETIME:

Load

RowNo() as ID,

CODE,

Date(SALEDATE) as SALEDATE,

Timestamp#(UPDATE,'DD/MM/YYYY hh:mm:ss') as UPDATE,

RATE

From ......

Now use below expressions

Sum(if(Date(SALEDATE,'DD/MM/YYYY')=Date(Floor(UPDATE),'DD/MM/YYYY'),RATE))

if(Date(SALEDATE,'DD/MM/YYYY')= Date(Floor(UPDATE),'DD/MM/YYYY') and Time(FRAC(UPDATE),'hh') >= '12', 'PM',

if(Date(SALEDATE,'DD/MM/YYYY')= Date(Floor(UPDATE),'DD/MM/YYYY') and Time(FRAC(UPDATE),'hh') < '12', 'AM',

'NOT MATCHING'))

Re: Date If Condition

Tue, 09 Sep 2014 10:06:06 GMT

Hi Siva,

Please find the attachment.

Thanks,

Vamsi