Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

Selection of Minimum Dates in Bar Chart

Hi Community,

I have one Bar Chart in which Dimension is MonthYear ( i.e Dec2016, Jan2017, Feb2017) and Expression is Sum(Sales)

So here requirement is :

When i select Jan2017 in list Box the bar chart has to show bar & values for only Jan2017 and Dec2016 and When i select Feb2017 in list Box the bar chart has to show bar & values for only Feb2017, Jan2017 and Dec2016

Thanks In Advance

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Provide sample data or sample application.

My expression working in my application.

View solution in original post

11 Replies
Not applicable

Hi Satish

What will happen when you select May 2017?

Just want to understand your full requirement.

Regards

sspawar88
Creator II
Creator II
Author

Hi,

It should select May2017, April2017, Mar2017, Feb2017, Jan2017, Dec2016.

Here Concern is only to select Minimum & equal dates value

varshavig12
Specialist
Specialist

Try this:

=sum({<MonthYear={"<=$(=Max(MonthYear))"}>}sales)

MK_QSL
MVP
MVP

Try this as bar chart expression

SUM({<MonthYear = {"<=$(=Date(Max(MonthYear),'MMMYYYY'))"}>}Sales)

sspawar88
Creator II
Creator II
Author

Hi Varsha,

Actaully i'm using two Expression one is Sum(Sales) & Second is Sum(Bonus)

I was just want to know the possible ways of doing this.

When i'm using

=sum({<MonthYear={"<=$(=Max(MonthYear))"}>}sales)

it shows error in calculated dimension.


sspawar88
Creator II
Creator II
Author

Hi Manish,

It shows no data to display.

Anonymous
Not applicable

Hi,

    As your requirement shows YTD I have developed sample YTD and Rolling 12 Months KPIs...

-Jai

varshavig12
Specialist
Specialist

Your dimension should be MonthYear

and Expression: =sum({<MonthYear={"<=$(=Max(MonthYear))"}>}sales)

MK_QSL
MVP
MVP

Provide sample data or sample application.

My expression working in my application.