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: 
jerryr125
Creator III
Creator III

Chart not taking into account a filter

HI - can you somehow set a chart not to take into account a filter ?

I am displaying the AMOUNT on a table by particular dimension and I DO NOT want the AMOUNT to change based upon the filtering criteria.

 

Thoughts ? Jerry

5 Replies
dplr-rn
Partner - Master III
Partner - Master III

Use set analysis to ignore a filter e.g. to ignore any selections of filter country
sum({<Country=>} Sales)
dplr-rn
Partner - Master III
Partner - Master III

If you want it to ignore all filters
Sum({1} Sales)
jerryr125
Creator III
Creator III
Author

close - how do I lock the date range ? that is - the date range does not take into account the filtered date range.

dplr-rn
Partner - Master III
Partner - Master III

Put the date range in the set analysis. it will lock to those dates.
e.g. sum of sales last 6 months
Sum( {<OrderDate={"<=$(=today()) >=$(=MonthStart(Addmonths(today(),-6)))"}>} LineSalesAmount)
Channa
Specialist III
Specialist III

 

 

=sum ( {<criteria= >} Amount)

Channa