topic Re: How to compare charts without using alternative states in QlikView

How to compare charts without using alternative states

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

Hi All,

I have two charts and 4 filters like chart 1 and chart 2.

filters having Supply 2, Supply chain, Supply 1 and Month.

Supply 2 filter is effected only Chart 1 and Supply chain reflected chart 2 and remaining filters will effects all charts.

if we use alternative state, Supply 2 filter is effects chart 1 and month filter is not effected.

please see the below example for your reference.

Please suggest me is it possible to achieve, if possible please suggest me how to achieve without using alternative state.

Thanks & Regards,

Lakshman

sunny_talwar — Wed, 20 May 2020 12:51:10 GMT

Switch Chart 1 to Inherited state and use this expression

=Sum({<Supply2 = State1::Supply2>}Sales)

Lakshman_1031 — Wed, 20 May 2020 16:22:09 GMT

Hi Sunny,

Thank you very much for your replay.

it's working fine.

If i make reset all button and select in field is Supply2 and Search string is Asia.

but it is not reflected in Current selection box and remaining filters is reflected.

if i select Supply2 it is not reflected in current selection.

please suggest me if we use alternative state field is reflected or not in current selection.

if possible please suggest me.