Need sheet to ignore filtering on other sheets

[#1]

Hi,

I have a QVW with multiple sheets where the users can filter the data by selecting year and/or month.  In addition, I have a sheet that displays the organization’s KPIs.  I need to have the objects in the KPIs sheet ignore any filtering done on any of the other sheets.  I remember this being in mentioned in one of the Designer course I took but I can’t find any info on this.

Any help would e greatly appreciated.

[#2]

Hi,

You can detach the objects in your sheet (right click in the object) this will make the chart frozen in its current state

Regards!

[derekjones · Accepted solution]

Hi there

All you need to do is add a 1 inbetween the { and < in your set analysis in every expression of your KPI's e.g.see bold in the below example (you replace SetAnalysisConditionA=ExampleA with any condition you are putting in)

=Sum( {1<SetAnalysisConditionA=ExampleA>} KPIValue )

All the best

Derek

[#4]

Hi,

Thanks for the feedback.  In my gauge chart I have this expression:

=firstsortedvalue({$<KPI={"Balance Sheet Leverage"},Updated={"<=$(=max(Updated))"}>} kpi_curr_val,-last_upd_dttm)
- firstsortedvalue({$<KPI={"Balance Sheet Leverage"},Updated={"<=$(=max(Updated))>="}>} kpi_targt_val,-last_upd_dttm)

When I change it to this it does not appear as if it is ignoring the filtering done on other sheets.

=firstsortedvalue({$1<KPI={"Balance Sheet Leverage"},Updated={"<=$(=max(Updated))"}>} kpi_curr_val,-last_upd_dttm)
- firstsortedvalue({$1<KPI={"Balance Sheet Leverage"},Updated={"<=$(=max(Updated))>="}>} kpi_targt_val,-last_upd_dttm)

[derekjones]

You need to lose the $ sign inbetween and just leave the 1. The $ sign represents the records of the current selection. The set expression {$} is thus the equivalent of not stating a set expression. What you have done is added the 1 to the $, $1 represents the previous selection, i.e. equivalent to pressing the Back button.

sum( {$} Sales )
returns sales for the current selection, i.e. the same as sum(Sales).

sum( {$1} Sales )
returns sales for the previous selection.

sum( {1} Sales )
returns total sales within the application, disregarding the selection but not the dimension.

Try the following...

=firstsortedvalue({1<KPI={"Balance Sheet Leverage"},Updated={"<=$(=max(Updated))"}>} kpi_curr_val,-last_upd_dttm)
- firstsortedvalue({1<KPI={"Balance Sheet Leverage"},Updated={"<=$(=max(Updated))>="}>} kpi_targt_val,-last_upd_dttm)

[swuehl]

Hi,

if you select Updated field in another sheet, the above expression will take that into account too. {1} disregards the current selection, but I think you then again add the Updated field selection to your set (the part with max(Updated)),

Not really sure what you are after, but a similar question was just answered here:

http://community.qlik.com/message/137146

Regards,

Stefan

[#7]

Thanks to all who responded.  This is working.