Chart issue

[NavinReddy]

Dear All,

Like this format i have every month Data,Here i dont have month Field

i have data like separated every month but i want to create a BAR chart with Month dimension

I Want to create a chart like this Format

Please help me some one to solve this issue

Thanks In Advance

Niranjan

[maxgro]

RESULT

SCRIPT

Source:

load * inline

[

row

Jan Jan Actual 400

Feb Jan Actual 400

Mar Jan Actual 567

Apr Jan Actual 567

May Jan Actual 567

Jun Jan Actual 400

Jul Jan Actual 788

Aug Jan Actual 400

Sep Jan Actual 456

Oct Jan Actual 345

Nov Jan Actual 400

Dec Jan Actual 400

Jan Plan 123

Feb Plan 567

Mar Plan 678

Apr Plan 567

May Plan 777

Jun Plan 888

Jul Plan 999

Aug Plan 543

Sep Plan 333

Oct Plan 345

Nov Plan 222

Dec Plan 500

];

Table:

NoConcatenate load

left(row,3) as m,

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

'Plan' as type

resident Source

where wildmatch(row, '*plan*');

Concatenate (Table) load

left(row,3) as m,

mid(row, 5,3) as m2,

SubField(row, ' ', 4) as v,

'Actual' as type

resident Source

where wildmatch(row, '*actual*');

DROP Table Source;

[NavinReddy]

Hi Masssimo,

I atteched excel dump

for that how can i create month field

please help me

Thanks in Advance

Niranjan

[Anonymous]

i dont see excel sheet attached...

[NavinReddy]

Sorry, please check now .

Regards,

Niranjan

[Anonymous · Accepted solution]

Please see attached QVW file .. hope this helps...

[NavinReddy]

Hi Vinay,

Thanks you So much

Greate Solution

Best Regards,

Niranjan

[Anonymous]

No issues .. Glad i was able to help you