Date

[smilingjohn]

HI All,

I have 1 table , in which there is a field name by date , I will not be using any master calendar becuase of date complication ,

But i need to know , i need to have a date set as opening date (01-12-2015) and one more date as closing balance ((31-12-2015),

And accordingly i have to use this in my charts ,

Can some one please suggest me how do we achieve this .

[SreeniJD]

You can convert this date into two separate date columns (Opening Date and Closing Date)

monthstart(date) as Open_Date

MonthEnd(makeDate(Year,Month)) as closing_Date

Sreeni

[senpradip007]

Can you share a sample qvw?

[smilingjohn]

Hi Pradeep PLease find the attachment of Sample qvw ,

When i click on any month i want in one text box a opening balance to be displayed and in another closing balance ,

I tried to follow the steps but could not get it , Can u please help me with this .

Thanks in advance .

[tamilarasu]

Hi,

Check the attachment and let me know whether this is fine or not.

[smilingjohn]

Thanks Tamil Nagraj

This is something what i wanted , But i need to know how do i store this in a variable , Becuase in chart i need to show the value for start date and as well the sum(valu) for end date .

Can u please help me with this ,

Regards

John

[smilingjohn]

the sum of value should be something like start date less than 30-08-2015,

How to store this in a variable ? and manuplate it in the expression

[smilingjohn]

Thanks a lot Tamil Nagraj you are awesome

[tamilarasu · Accepted solution]

I'm glad I could help . Hope you resolved the problem. You can store  the values in variable like below.

Got to Settings - Variable over view and type like below. After that, we can use this in chart like $(vOpen_Date)