topic Re: Conditional IF in QlikView

Conditional IF

Wed, 25 Nov 2020 16:16:04 GMT

I have 2 columns,date and rate. When date is=today() I want that respective rate column. I want to do this in the script. I have attached a sample excel

Thanks for your help

Re: Conditional IF

sunny_talwar — Fri, 04 Mar 2016 23:29:04 GMT

I don't see a rate field? Have you attached the right Excel file? Not sure I am able to relate your Excel to the description. please elaborate

Re: Conditional IF

Sat, 05 Mar 2016 03:33:25 GMT

HI Sunny

I think I attached the wrong file. I am sending the right file now. For date=todays date I want to fetch that respective rate column in my script part

Thanks

Re: Conditional IF

avinashelite — Sat, 05 Mar 2016 03:42:18 GMT

try like this:

if(date(date_field,'DD-MM-YYYY')=date(today(),'DD-MM-YYYY'),rate) as new_rate

if(num(date_field)=num(today()),rate) as new_rate

Re: Conditional IF

Digvijay_Singh — Sat, 05 Mar 2016 04:30:10 GMT

May be try smthg like this -

Temp:

LOAD Sno,

Name,

Direction,

CURR,

VALUE,

ENDDATE

FROM

test.xlsx

(ooxml, embedded labels, table is Sheet1);

Final:

Load VALUE

Resident Temp

Where ENDDATE=today();

Drop table Temp;

Re: Conditional IF

avinashelite — Sat, 05 Mar 2016 11:50:53 GMT

didn't find the rate column in the attachment could you check your attachment ??

Re: Conditional IF

sunny_talwar — Sat, 05 Mar 2016 13:23:59 GMT

Still don't see the Excel being changed. No rate column still

Re: Conditional IF

Sat, 05 Mar 2016 20:36:39 GMT

Thank you, this seems to have worked. Will try again at work on Monday and update back. Really appreciate it