Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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)
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
Can you share a sample qvw?
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 .
Hi,
Check the attachment and let me know whether this is fine or not.
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
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
Thanks a lot Tamil Nagraj you are awesome
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)