Bar Chart Issue

[er_mohit]

Hi Friends

I'm stuck of facing the problem, Please see below attached image and i want to build that bar graph dynamically.

I also try to build a logic on back end in Master Calendar but doesn't get succeed.

Any help will be appreciated

Thanks & Regards

Mohit

[er_mohit]

Hi VISHWARANJAN

Thanks for reply.

When i reload it execution fail

[perumal_41]

PFA,

hope it helps

[Anonymous · Accepted solution]

Hi,

due to your date formats I had to modify the script, see attached qvw!

Hope this helps.

Best regards

Stefan

[er_mohit]

Superb Stefan Kunte

Good job as expected.

Thanks  & Regards

Mohit

[er_mohit]

Thanks for reply as mentioned in screenshot above i want same alike in graph.

i see your attachment it solve the purpose for Quarterly wise not month wise . like

Suppose if user select Year = 2013 then this graph 'll show

Q1, Q2, Q3, Q4, H1,H2,YTD Dec because all the data have been covered up for all month for Actual and base.

similarly if user select 2014 then Graph 'll show

Q1,Q2,Q3,H1,YTD Sep

and in above show graph the data upto Aug so for that

Q1,Q2,July & Aug,H1,YTD Aug

hope it helps

[#7]

hi

Superb Stefan Kunte  

Thanks & Regards

Vishwaranjan Kumar

[er_mohit]

Hi Stefan Kunte

I have a problem in this regards and want a new solution for that during implement of this it repeats the value thrice a time and also for two combined month is not true it always pick up MaxMonth and MaxMonth-1 .

I need if Month complete the Quarter then Quarter show otherwise not show. like

Year 2014 have data upto Aug so, my dynamic dimension is

Q1,Q2,H1,July & Aug,YTD Aug 

as shown above attached graph.

Is there any other solution on the based of both field Month and MaxMonth field  to put an if condition

Regards

Mohit

[Anonymous]

Hi,

then you have to modify the date range of your calendar from the example you posted you have:

LET vDateMin = Num(MakeDate(2006,1,1));

LET vDateMax = Num(Today());

define these start and enddates according to their occurence in your facttable for example:

Temp:

load

min(Date) as Min,

max(Date) as Max

Resident Facttable;

LET vDateMin = Num(peek('Min', 0, 'Temp'));

LET vDateMax = Num(peek('Max', 0, 'Temp'));

drop table Temp;

Best regards

Stefan

[er_mohit]

Ok. thanks for your reply. As per your code i just want to one table means merging of two tables to Final table but i got thrice time count of Quarters and Half Year . Please see attached.

I want this both tables into One with no repetition

Any help will be appreciated.

Thanks & regards

Mohit

[Anonymous]

Hi,

yes your Calendar will "grow" if you join the ChartDimension Field into the Calendar because for example Half Year and Quarter have common dates.

Best regards

Stefan