topic Alternate States selection in default chart in QlikView

Alternate States selection in default chart

shyamcharan — Wed, 13 Jul 2016 11:12:59 GMT

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.

maniram23 — Wed, 13 Jul 2016 11:26:18 GMT

Hi,

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

kaushiknsolanki — Wed, 13 Jul 2016 11:26:46 GMT

Hi,

Try this,

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

Regards,

Kaushik Solanki

shyamcharan — Thu, 14 Jul 2016 03:56:19 GMT

Thank you all for the help. Your suggestions helped.