Chart to ignore selected filters

[#1]

I currently have a chart developed (QV11) that contains both set analysis and a standard "IF Statement" and i need to ignore any filters selected on the same sheet.  I am familiar with how to code it using the "1" character in set analysis but how do i code the IF statement to ignore the selected filters?  Is there a general setting anywhere within a chart's properties to tell it to ignore filters?

here is the IF statement code:

if([Project Class]='Large' and [Program-SRV]='V9/V10 Service Delivery' and State<>'Cancelled' and State <> 'Completed',

Date(Min([Start Date])) & ' - ' & Date([End Date]) & '

' & ([End Date]-Min([Start Date])) & ' Total Days

'&Fabs([End Date]-Today()) & ' Days ' & if(([End Date]-Today()) <0,'Late','Left'))

[swuehl]

Try maybe like (for all fields to check)

if( only({1} [Project Class]) ='Large' and ...

[Anonymous]

"...i need to ignore any filters selected on the same sheet..." - this is the case for alternate set, I guess.  If you have the filters in a "defaul set" and the chart in an "alternate set", this would work as described.

[#4]

how to i set filters/charts in a default or alternate set?

[Anonymous · Accepted solution]

Steve,

Start from the document properties.  On the General tab, click button Alternate States.  Add a state, for exapmle you call it S1.

After this, go to the chart properties, General tab.  Now there is Alternate State drop-doen on the top - choose S1.

All other objects are in inherited state unless you change them.

Regards,

Michael

[#6]

michael solomovitch is right you should do some alternate states. there is a video on youtube which is explaingig that.  Qlikview Alternate States - YouTube

yoel tordjman

[#7]

thanks, i will watch video.