Month to date chart

[anuradhaa]

I need to plot the data in a line chart.

demenssion is dates (1,2,3,4,5.....)

i need to have two lines one reprecent curent months data for the relavent day and other reprecent prv.month data.

ex - i have 100 for may 5th and 400 for june 5th.

so i need to have both the values in same chart which has the days in X-Axis.

I know how to do this with month and years. but can't find a solution for month and days.

Thanks

[tresesco]

PFA.

Hope this helps.

[#3]

Hi Anu,

U can use the below expression in Expression text box in Sort tab.

SubField(Date1,'-',1)&'-'&SubField(Date1,'-',2)&'-'&SubField(Date1,'-',3)

Please find the below attachment, if u have any concerns, let me know.

Regards,

Kabilan K.

[anuradhaa]

Hi, Thanks For Your Reply .

I have change my data according to your QVW. I can't see 2 lines.

My expressions are

Sum({<Month={'$(vCurrMonth)'}>}[SALES])

Sum({<Month={'$(vPrevMonth)'}>}[SALES])

There i have eneter a text boxes to chek variables and the two text boxes display correct months,

I also include two expressions in text onbect. but it display the sum of all data and no brake down for month.

Your example is working nice. and i don't think why my one is not working.

finally i have change the $(vCurrMonth) and PUT month names, numbers but still the same result.

Pls help me.

Thanks

[anuradhaa]

Thanks for you reply, but this is not what i want. tresesco example is good. but it is not working for me

[narender123]

Hi,

Show your expression or show sample qvw.

Thanks

[anuradhaa]

I have added variable vCurrMonth and when i but below expression in text box it shows Jun

=$(vCurrMonth)

Then use below expression to get sum,

=Sum({<T_Month={'$(vPrevMonth)'}>}SALES) and it shows 0

then i change that expression to

=Sum({<T_Month={'Jun'}>}SALES)

Then it shows the value.

[tresesco]

What is the dimension you are using? Can you share a sample file?

[anuradhaa]

Hi ,

Please chk below attachment

[tresesco]

Are you sure that your variables are right? as you can see, you are talking about vCurrMonth , but while mentioning the expression, you wrote vPrevMonth ?