topic Re: Static chart in qlikview in QlikView

Static chart in qlikview

ramanarayan — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Static chart in qlikview

YoussefBelloum — Wed, 28 Mar 2018 09:33:17 GMT

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

Re: Static chart in qlikview

jaumecf23 — Wed, 28 Mar 2018 09:36:26 GMT

Why you can't use Set Analysis ?

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