Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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 - Specialist
Partner - Specialist

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.

Anonymous
Not applicable

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

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