topic Re: Code Error in QlikView

Code Error

NavinReddy — Wed, 28 May 2014 21:27:31 GMT

Dear All,

Please check below code its not working for me

please find the Notepad

could some one help me to solve this Error

Best Regards,

Niranjan

Re: Code Error

its_anandrjs — Wed, 28 May 2014 21:44:43 GMT

What error you get and it seems no error in the code but try with below code

Source:

LOAD Building,

[Jan Actual Dollars],

[Feb Actual Dollars],

[Mar Actual Dollars],

[Apr Actual Dollars],

[May Actual Dollars],

[Jun Actual Dollars],

[Jul Actual Dollars],

[Aug Actual Dollars],

[Sep Actual Dollars],

[Oct Actual Dollars],

[Nov Actual Dollars],

[Dec Actual Dollars],

[Jan Actual SQF],

[Feb Actual SQF],

[Mar Actual SQF],

[Apr Actual SQF],

[May Actual SQF],

[Jun Actual SQF],

[Jul Actual SQF],

[Aug Actual SQF],

[Sep Actual SQF],

[Oct Actual SQF],

[Nov Actual SQF],

[Dec Actual SQF]

FROM

(ooxml, embedded labels, table is [Data ]);

Table:

NoConcatenate

load

left(Building,2) as m,

SubField(Building, ' ', 2) as v,

'SQF' as type

resident Source

where wildmatch(Building, '*SQF*');

Concatenate (Table)

load

left(Building,2) as m,

mid(Building, 5,2) as m2,

SubField(Building, ' ', 3) as v,

'Dollars' as type

resident Source

where wildmatch(Building, '*Dollars*');

DROP Table Source;

Re: Code Error

NavinReddy — Wed, 28 May 2014 21:57:04 GMT

Hi Anand Chouhan,

I atteched excel sheet in that sheet there is no Month field

i want to create month field

if i select month (jan,feb,march,apr..........) it will come

Please help me to do this

Regards,

Niranjan

Re: Code Error

NavinReddy — Wed, 28 May 2014 22:14:45 GMT

Hi Anand Chouhan,

Any idea....

Best Regards,

Niranjan

Re: Code Error

SergeyMak — Thu, 29 May 2014 01:29:08 GMT

Please share your files. Because there is only a spreadsheet with a table.

But I see in discussion that probably there were other files

Re: Code Error

NavinReddy — Thu, 29 May 2014 11:50:46 GMT

Hi Sergey Makushinsky,

I atteched excel in that excel sheet no month filed

how can i create month field using(jan,feb,mar........)Fields

that what my issue

Best Regards,

Niranjan

Re: Code Error

Anonymous — Thu, 29 May 2014 19:34:49 GMT

Hello, Niru Niri.

Please, take a look on the attached QVW. I think it may show you how to solve your problem. I'm going to attach the same file to your other posts about this issue too.

Hope it helps.