Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
psankepalli
Partner
Partner

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

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You can use the scope operator :: like

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

View solution in original post

4 Replies
swuehl
MVP
MVP

You can use the scope operator :: like

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

svenkita
Creator II
Creator II

Check out the SALES OVERLAP tab in

what is new in qlikview 11

prabhu0505
Specialist
Specialist

Below option is also available.

Alternate_State.PNG

psankepalli
Partner
Partner
Author

Thank you Swehl. this helped me!!