topic Re: day calculation in QlikView

day calculation

Fri, 22 Feb 2013 13:19:22 GMT

i have the following table

location Number Day

---------- ----------- ------------

Mezyed MQ2011 Mon

Another Table

Location Days

------------ -----------

Mezyed Mon | Wed

where this table shows what days for each location would be odd numbers, so we have to check if the last number in Number is odd to match the day.

This is very important. If there is another way for table 2 to be designed to make it easier then bring it on. but first table not to be changed

THANKS
BILALELABD

manideep78 — Mon, 25 Feb 2013 14:55:43 GMT

Hi,

I didn't understood what you have said

Please can you explain your problem clearly.??

Sat, 02 Mar 2013 12:04:58 GMT

I have medical number as 'BM021234' so i need to check the last character if odd or even, that is 4. how can i do this??