topic Re: MonthToDate not working in table in QlikView

MonthToDate not working in table

Wed, 08 Jan 2014 04:17:44 GMT

Hi All,

i am creating a table that have Month to Date value in it, using set analysis.

if i use "Department" as dimension in the table, the MTD value will shown correctly.

But if i change to "Date" dimension the value seems to breakdown for each day not accumulated.

I have attached an image showing what result that i am expecting and the result that currently QV shown.

I use 3 selection list box in the report, "Year" (e.g 2012,2013), "Month" (Jan, Feb), and Day (e.g 1,2,3,4) and must be at least one value selected properties are checked.

and my set analysis for MTD is : sum({$<Day={"<= $(=max(Day))"}>} [Sales Amount Gross]).

Thanks in advance.

Re: MonthToDate not working in table

Wed, 08 Jan 2014 05:19:17 GMT

PFA... Hope it will help you

Regards

Nirmal

Re: MonthToDate not working in table

VishalWaghole — Wed, 08 Jan 2014 06:34:44 GMT

Hi Piyajate,

Try this expression for your MTD

=sum({<Date = {">=$(=Date(Max(Monthstart(Date))))

<=$(=Max(Date))"}>} [Sales Amount Gross])

Hope it will work for you.

- Regards,

Vishal Waghole

Re: MonthToDate not working in table

Wed, 08 Jan 2014 08:24:43 GMT

Hi,

i am still not getting the expected result.

What i was expecting is let say the value are like below :

1 Jan = 5
2 Jan = 10
3 Jan = 15

for the MTD i am expecting that for 2 Jan it will be accumulated between 1 and 2 Jan value (5+10) which is 15, like below :

Date | MTD Value
1 Jan | 5
2 Jan |15
3 Jan | 30

if the dimension were change to other than "Date" then my MTD expression will work correctly, but not if using Date dimension

Re: Re: MonthToDate not working in table

Wed, 08 Jan 2014 08:37:43 GMT

PFA.... refer the two straight tables hope it will helps you

Re: MonthToDate not working in table

Thu, 09 Jan 2014 04:39:37 GMT

Hi Nirmal,

it worked!

Thanks alot!

Re: MonthToDate not working in table

Thu, 09 Jan 2014 04:40:18 GMT

Hi Nirmal,

it worked!

Thanks alot!