topic Re: Month End's MTD Values in QlikView

Month End's MTD Values

rohit214 — Wed, 27 Mar 2013 10:55:20 GMT

Hi All,

Here i attached my sample data file and i want the data shown in below table.

Dim1	MTD%	Feb2013	Jan 2013
A	9.40	6.80%	4.00%

In Dim1 where i am using my feild

in MTD% that will show my maximun date MTD% i.e 26-03-2013 MTD% Value

In Feb 2013 That will show my 28-02-2014 MTD%

In Jan 2013 that will Show my 31-01-2013 MTD%.

If user select any of the date my MTD% Column value should be the selcted date value and rest of all as i explained above

and suppose if user select 25-02-2013 date then MTD% should be value on that date .

Thanks & Regards

Rohit

Re: Month End's MTD Values

Gysbert_Wassenaar — Wed, 27 Mar 2013 11:11:34 GMT

See attached qvw

edit: updated qvw

Re: Month End's MTD Values

rohit214 — Wed, 27 Mar 2013 11:42:31 GMT

Hi Gysbert,

Thanks for you answer but in dummy data its containning data for 2013 but in my actula data my date starts from 2011 so for that i have to wright too many expression so can i have any other option.and second thing if uesr selects date 23-02-2013 so rest of 2 colum became null i want when user selects 23-02-2013 my MTD% value should be selected date after that it should show data for 31-01-2013 and extra colum should disappear dynamically.

Thanks

Rohit

Re: Month End's MTD Values

rohit214 — Wed, 27 Mar 2013 13:19:57 GMT

hi Gysbert,

i have one more doubt suppose in my data there is ramdom data like now what file i shared with you contains the data in positive values in increasing order but in data there is some -ve values and some time values are smaller thar previous date so how can i get those value with same logic, again i am sending one more raw data file,

Thanks

Rohit

Re: Month End's MTD Values

rohit214 — Wed, 27 Mar 2013 14:14:20 GMT

any one....

Re: Month End's MTD Values

rohit214 — Thu, 28 Mar 2013 07:05:19 GMT

Hi Gysbert, Can you please help me to sort out from this problem that would be more appreciable,

Please use attached data.

Thanks

Rohit

Re: Month End's MTD Values

rohit214 — Thu, 28 Mar 2013 09:40:33 GMT

Hi Gysbert,

Thanks for reply,

Dim1	MTD%(Latest date i.e. 26-03-2013 MTD% Value)	Feb 2013(i.e. 28-02-2013 MTD% Value)	Jan 2013(i.e 31-03-2013 MTD % Value)
A	-.77%	-.38%	-.21%

In Dim 1 Is a field value

In MTD% maximum date i.e latest date which is 26-03-2013 MTD% value as per the excel file i have attached

In Feb 2013 value comes from feb's month last date MTD% value i.e. 28-02-2013 MTD% Value

In Jan 2013 value comes from Jan's month last date MTD% value i.e. 31-01-2013 MTD% Value

and so on...

hope you understood and please find the attached file.

Thanks

Rohit