How to use State A Filter into State B Charts at Alternate States in Qlikview

[psankepalli]

Hello Everyone,

I am working on Alternate states for comparison dashboards. Lets say I have "State A" and "State B" Alternate States. is there a way I can use the State A calendar for the State B Charts through GetFiledsSelect function. or any other functions?

Please help!

Thanks

Prasanna

[swuehl · Accepted solution]

You can use the scope operator :: like

=Sum({StateA<Month = StateB::Month, Year = StateB::Year>} Value)

[svenkita]

Check out the SALES OVERLAP tab in

what is new in qlikview 11

[prabhu0505]

Below option is also available.

[psankepalli]

Thank you Swehl. this helped me!!