Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Provide sample data or sample application.

My expression working in my application.

View solution in original post

11 Replies
Highlighted
Not applicable

Hi Satish

What will happen when you select May 2017?

Just want to understand your full requirement.

Regards

Highlighted
Creator II
Creator II

Hi,

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

Here Concern is only to select Minimum & equal dates value

Highlighted
Specialist
Specialist

Try this:

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

Highlighted
MVP
MVP

Try this as bar chart expression

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

Highlighted
Creator II
Creator II

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.


Highlighted
Creator II
Creator II

Hi Manish,

It shows no data to display.

Highlighted
Creator II
Creator II

Hi,

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

-Jai

Highlighted
Specialist
Specialist

Your dimension should be MonthYear

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

Highlighted
MVP
MVP

Provide sample data or sample application.

My expression working in my application.

View solution in original post