Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to restrict values with in a dimension in the chart itself

Hi Folks,

I have the below bar chart, In the report month dimension here I want it to show values that are greater than March 2017 (> March 2017). How can I achieve that?

report month limit.jpg

FYI I tried standard dimension limit chart property options that don't seem to work and server the purpose. Also, limiting data in load script thru where clause is not working or not an option here for me.

Thanks,

Gaurav

4 Replies
Highlighted
Partner
Partner

Re: How to restrict values with in a dimension in the chart itself

Hi,

Have you tried with Set Analysis?

Saludos.

Highlighted
Master
Master

Re: How to restrict values with in a dimension in the chart itself

Try like this in dimension

=if(date(date#([Report Month],'MMMMM YYYY'),'MMMMM YYYY')> 'March 2017', [Report Month])

Highlighted
Creator
Creator

Re: How to restrict values with in a dimension in the chart itself

No not yet.

Highlighted
Contributor II
Contributor II

Re: How to restrict values with in a dimension in the chart itself

Use the Calculated Dimension option and try below in Dimension definition :

=if(date(date#([Report Month],'MMMMM YYYY'),'MMMMM YYYY')> 'March 2017', [Report Month])