Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please see attached QVW file .. hope this helps...
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;
Hi Masssimo,
I atteched excel dump
for that how can i create month field
please help me
Thanks in Advance
Niranjan
i dont see excel sheet attached...
Sorry, please check now .
Regards,
Niranjan
Please see attached QVW file .. hope this helps...
Hi Vinay,
Thanks you So much
Greate Solution
Best Regards,
Niranjan
No issues .. Glad i was able to help you