Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Pls Help to show currrent Year data for present months

Hi All,

Attached QVw file for referance

Capture.PNG

1) I want to display data by default current year data from Jan 2015 to current month i.e.Sep 2015 & don't want to show Oct,nov,Dec month data
    as shown in image. I written 12 hard code expressions for each month which i want to make it dynamic expression.

Capture.PNG

2) I want to display Rolling 13 months data if i select Year 2014 i.e. Dec 2013 to Dec 2014

Please find attached QVW file for referance n help me on this.

Thanks

5 Replies
Highlighted
Master
Master

Hi,

Please try:

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Max(Date), -13))<=$(=Date(Max(Date)))’}>} [DTL SUM]/$(vTotal)*100 )

Highlighted
Not applicable

Hi Neetha,

I am not getting expected result from your expression please see attached QVW file for

refereance in which i am using only Product as Dimension.Pls help me with QVW.

There are 2 requirement mentioned in main post.

Thanks

Highlighted
Master
Master

hi rahul,

Maybe try:

SUM({<MonthYear={">=$(=Date(yearstart(today()),'MMM-YY'))<=$(=Max(MonthYear))"}>} [DTL SUM]/$(vTotal)*100)

Highlighted
Not applicable

Hi neetha,

No i am not to get expected result based on 12 expression i want to make dynamic

not with single expression will work. Not using MonthYear as dimension. Pls see attached QVW for ref.


Highlighted

try like this :

In the Dimension add a calculated Dimension or you can calculate this column in the script

month([Month Year]) and pivot it.

create one more year column from the Year([Month Year]) as Year_column

In the expression :

if(Year_column=year(today()),sum([DTL SUM]),RangeSum(Above(TOTAL [DTL SUM], 0, 13)))