topic Re: Date in QlikView

Date

smilingjohn — Thu, 15 Oct 2015 04:20:34 GMT

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 .

Re: Date

SreeniJD — Thu, 15 Oct 2015 04:26:19 GMT

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

Re: Date

senpradip007 — Thu, 15 Oct 2015 04:27:58 GMT

Can you share a sample qvw?

Re: Date

smilingjohn — Thu, 15 Oct 2015 04:35:04 GMT

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 .

Re: Date

tamilarasu — Thu, 15 Oct 2015 04:53:48 GMT

Hi,

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

Re: Date

smilingjohn — Thu, 15 Oct 2015 05:01:09 GMT

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

Re: Date

smilingjohn — Thu, 15 Oct 2015 05:06:23 GMT

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

Re: Date

smilingjohn — Thu, 15 Oct 2015 05:11:49 GMT

Thanks a lot Tamil Nagraj you are awesome

Re: Date

tamilarasu — Thu, 15 Oct 2015 05:19:59 GMT

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)