CHART ISSUE

[#1]

Here is the sample data, I am trying to create a chart with the following  Calculated dimension and I am using the value list function to create the dimension

. My valueList is ('Incurred ','Paid')

. Incurred = Sum(Ind Paid-Ind Rec) and Paid =(Ind Paid+ Exp Paid)

I am using Two Diemsions in the Bar chart

1st one is

$(vValuelist)and second is 'Q'& Ceil(Month/3)

I wanna calculate the Incurred and Paid for each Quarter represented by  Bars, for example If I  select  <= 'Mar' I should see the Bar for Q1 for Incurred and Paid seperatley

If Month > Mar and <= Jun'  then I expect to see Bar 'Q1' and Bar 'Q2'  again for both Incurred and Paidand so on.  and Q2 includes Q1 and Q2, Q3 includes (Q1,Q2 and Q3), its all cumulative.

Please let me know if this good enough info.

Attached is the real Sample data

[#2]

I dont have master Calendar in my script,

[#3]

Any more sugestions??

[sunny_talwar]

The attached sample did not help you achieve what you were looking for?

[#5]

No my results dont work, in my case I am not getting two bars, If I select <= Mar I get Q1 but when I select Apr I only get Q2, I wanna seee both Q1 and Q2 like your qvw

[#6]

and I dont have master calendar in my script

[sunny_talwar]

Did you try this in your set analysis?

{<Month = {"$(='>=' & 1 & '<=' & Max(Month))"}>}

How is MonthField created? Can you share where you have Month created?

[#8]

Yes I am using the same expression

and I am calculating  the month as

Month(Date#([As of],'YYYYMM')) As Month

cuz [As Of] is in 'YYYYMM' format

[sunny_talwar]

That is very strange, I am not sure why it wouldn't work for you if it is working in the attached application.

[#10]

I have started a new thread called "BAR CHART WITH LINE ISSUE"

and have attached the actual QVD, Dashboard and the issue description with the Image.  Can you please look into it

[#11]

Can you pls help me with my Bar Chart issue