topic Re: Current Month Issue in QlikView

Current Month Issue

azmeerrehan — Fri, 30 Jun 2017 13:56:46 GMT

I am trying to show the Month to Date number for the month today. So If its June today, I would like to show the data for Jun only. My data is a MTD data, so I have created a variable (vMonthToday=Num(Month(Today()))) and My expression is

sum({<Month = {$(=vMonthToday)}>} Sales), it works perfectly fine for YTD with this expression

sum({<Month = {"<=$(=vMonthToday)"}>} Sales).

So I would like to show only Month(Today) data . I expect to see 2017 Jun = 2315 only and not the cumulative.

Attached please find the sample

Re: Current Month Issue

Anonymous — Fri, 30 Jun 2017 14:03:30 GMT

Try expression as below

sum({<Month = {"$(vMonthToday)"}>} Sales)

Re: Current Month Issue

azmeerrehan — Fri, 30 Jun 2017 14:04:38 GMT

Doesnt work, already tried that

Re: Current Month Issue

Anil_Babu_Samineni — Fri, 30 Jun 2017 14:06:52 GMT

I don't have Qlikview software. Does Month field has number values rather month names. Could be miss behaviour over month field? Check from your end

Re: Current Month Issue

lironbaram — Fri, 30 Jun 2017 14:17:12 GMT

your problem that the month field isn't numeric but text , and the your variable was numeric

i prefer to have a field motnhyear with the first date of the month as the value

then it's esayier to work have a look at the attach example

it better to use mothyear field because month alone isn't good enough because it only work if you have one year of data

Re: Current Month Issue

Anonymous — Fri, 30 Jun 2017 14:18:18 GMT

Ofcourse you need to change variable to have string of month and not the number to make above expression work.

Thanks

Re: Current Month Issue

kennethmash — Fri, 30 Jun 2017 14:42:26 GMT

!Hi Rehan

Try the attached sample. Your Month is not numeric which is what is causing the problem

Re: Current Month Issue

Anonymous — Fri, 30 Jun 2017 15:50:31 GMT

You Can Try This Formula's

Last Month to-date =sum({<Year= {'$(=max(Year)-1)'},Month={'$(=month(Today()))'}>}Sales)

Current Month to-date =sum({<Year= {'$(=max(Year))'},Month={'$(=month(Today()))'}>}Sales)

Last Year to Date = =sum({<Year={'$(=max(Year)-1)'},Month ={'<=$(=num(month(Today())))'}>}Sales)

Current Year to Date= sum({<Year={'$(=max(Year))'},Month ={'<=$(=num(month(Today())))'}>}Sales)