topic Urgent Pls Help me out in QlikView

Urgent Pls Help me out

Fri, 30 Mar 2012 05:38:28 GMT

Hi,

Can Anyone Help me on below Expression Please do the needful????

Kindly help me how to compare two date:

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

Example:

let vCurrMonthYear=MonthName(Today());

LOAD RES_ID,
RES_NAME,
month(Date) as MonthName

FROM
(biff, embedded labels, table is Sheet1$);

IF(vMonth=MonthName) then

STORE ResourceFile INTO E:\ResourceFile.qvd (QVD);

Else

STORE ResourceFile INTO E:\Resourcee.qvd (QVD);

Endif

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

After compare vMonth=MonthName, MonthName giving me Null Values.

in Monthname not carry value.

Kindly help me.

Regards

Ravi

Urgent Pls Help me out

Fri, 30 Mar 2012 05:42:38 GMT

Hi Ravi,

If you call a variable, use following syntax for the variable: $(vMonth).

Your expression (comparison) would then be

IF $(vMonth) = MonthName THEN ...

Hope this helps you further.

Regards,

sebablum

Urgent Pls Help me out

beunderf — Fri, 30 Mar 2012 06:06:40 GMT

Could you sent an example of your Date.xls?

Urgent Pls Help me out

Fri, 30 Mar 2012 06:21:03 GMT

First, it is not possible to simply get the value of 'MonthName' like this.

As it is a column name, in the loading script, it must return NULL in MonthName.

I think what you try to do is to split the data into two files.

So, I think you should use two tables to keep the data using 'where'

Urgent Pls Help me out

sivarajs — Fri, 30 Mar 2012 06:27:05 GMT

Whats your vMonth variable holds???

Sivaraj S

Urgent Pls Help me out

CELAMBARASAN — Fri, 30 Mar 2012 06:38:46 GMT

Hi,

Can you explain what your trying to do here by comparing dates?What value vMonth variable has?

Celambarasan

Urgent Pls Help me out

Fri, 30 Mar 2012 06:48:08 GMT

Hello Friends,

I am comparing both loaded data field MonthName and Current Month Name.

Only I comparing both date.

Can you Please help me out??

Regards

Ravi Gupta

Urgent Pls Help me out

sivarajs — Fri, 30 Mar 2012 06:51:01 GMT

can you check this

let vmonth=month(today());

if('$(vmonth)=monthname')

Sivaraj S

Urgent Pls Help me out

CELAMBARASAN — Fri, 30 Mar 2012 07:02:15 GMT

Hi,

Check with this approach.

let vCurrMonthYear=MonthName(Today());

ResourceFile:
LOAD RES_ID,
RES_NAME,
month(Date) as MonthName

FROM
(biff, embedded labels, table is Sheet1$) where month(Date) = vCurrMonthYear;

STORE ResourceFile INTO E:\ResourceFile.qvd (QVD);

Drop Table ResourceFile;

Resourcee:
LOAD RES_ID,
RES_NAME,
month(Date) as MonthName

FROM
(biff, embedded labels, table is Sheet1$) where month(Date) <> vCurrMonthYear;

STORE Resourcee INTO E:\Resourcee.qvd (QVD);

Drop Table Resourcee;

Hope this your need

Celambarasan

Urgent Pls Help me out

Fri, 30 Mar 2012 07:04:56 GMT

Celambarasan is correct.

I believe it is what you need.