topic Re: Month to date chart in QlikView

Month to date chart

anuradhaa — Thu, 27 Jun 2013 06:43:06 GMT

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

Re: Month to date chart

tresB — Thu, 27 Jun 2013 07:50:55 GMT

PFA.

Hope this helps.

Re: Month to date chart

Thu, 27 Jun 2013 07:54:35 GMT

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.

Re: Month to date chart

anuradhaa — Thu, 27 Jun 2013 11:25:50 GMT

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

Re: Month to date chart

anuradhaa — Thu, 27 Jun 2013 11:27:33 GMT

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

Re: Month to date chart

narender123 — Thu, 27 Jun 2013 11:34:16 GMT

Hi,

Show your expression or show sample qvw.

Thanks

Re: Month to date chart

anuradhaa — Thu, 27 Jun 2013 11:38:38 GMT

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.

Re: Month to date chart

tresB — Thu, 27 Jun 2013 11:39:56 GMT

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

Re: Month to date chart

anuradhaa — Thu, 27 Jun 2013 11:58:37 GMT

Hi ,

Please chk below attachment

Re: Month to date chart

tresB — Thu, 27 Jun 2013 12:00:12 GMT

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 ?

Re: Month to date chart

tresB — Thu, 27 Jun 2013 12:03:41 GMT

Anuradha,

Go to the variable declaration section and put '=' before the expressions of the variables.

Thanks.

Re: Month to date chart

narender123 — Thu, 27 Jun 2013 12:06:18 GMT

Hi Anu.

Your qvw is not working because you have not added = in your documeny property>variable>

Here u have written

Month(Max(date))

replace it with

=Month(Max(date))

Thanks

Narender

Re: Month to date chart

narender123 — Thu, 27 Jun 2013 12:07:25 GMT

Find the attachment

Re: Month to date chart

anuradhaa — Thu, 27 Jun 2013 12:07:53 GMT

Greate , it works.

Thank you very much

Re: Month to date chart

anuradhaa — Thu, 27 Jun 2013 12:09:35 GMT

Thanks, Narender.

Thank you very much. i didn't select your answer as Correct answer, because tresesco give me that answer first. Your answer also correct. sorry for that.

Have a Nice day .