Static chart in qlikview

[ramanarayan]

HI QV Experts,

I have a month dimension in my data and a chart in which i use the same month dimension.

I have a requirement where regardless of the month i select, the chart should not change. HOwever, i have other filters to which the chart should change accordingly except this month dimension.

I need to acheive this without having to use set analysis or alternate state.

Thanks

[YoussefBelloum]

I see three solutions:

1. Set analysis (you don't want it)

2. disconnect object (you will loose all connections with all the dimensions fields)

3. create a disconnected table like attached below

[jaumecf23]

Why you can't use Set Analysis ?

With Set Analysis an Expression like this : =sum({<Month>}[Sales units]) will work perfectly.