Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
khigaurav999
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
fvelascog72
Partner
Partner

Hi,

Have you tried with Set Analysis?

Saludos.

shiveshsingh
Master
Master

Try like this in dimension

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

khigaurav999
Creator
Creator
Author

No not yet.

abhishri031088
Contributor II
Contributor II

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

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