QlikView App Dev

[azmeerrehan]

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

[Anonymous]

Try expression as below

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

[azmeerrehan]

Doesnt work, already tried that

[Anil_Babu_Samineni · Accepted solution]

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

[lironbaram]

hi

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

[Anonymous]

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

Thanks

[kennethmash]

!Hi Rehan

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

[Anonymous]

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)