Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
shyamcharan
Creator III
Creator III

Alternate States selection in default chart

Hi Experts,

I do have scenario where I allow the users to select any two time periods and see the variance between them.

However, I do have chart that shows the variance by time period which is consecutive. Please see the attached example.

My requirement is to allow the year selection on Previous and Current Alternate States to affect the chart below which is in default state.

If i select '2012' in Previous and 2015 in Current the chart below should show only those two years.

Can anyone pleas suggest how to achieve this?

Thanks in advance.

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Try this,

sum({<Year = A::Year>+<Year = B::Year>}Activities)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

3 Replies
maniram23
Creator II
Creator II

Hi,

See the attached file. It will help full for you.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Try this,

sum({<Year = A::Year>+<Year = B::Year>}Activities)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
shyamcharan
Creator III
Creator III
Author

Thank you all for the help. Your suggestions helped.