topic Re: Help on Chart Click in QlikView

Help on Chart Click

Thu, 04 Feb 2016 17:25:48 GMT

Hi All,

I have one requirement that I have two pivot tables which are created country wise with some data like Area, product, unit etc...

My requirement is if i click on any expression column value (for ex 433 in Unit1 column) then detailed data table will enable and Country wise tables will hide. This i have achieved using conditional hiding but if you click on India country pivot table then India filter should apply but this is not happening. Data is showing for both countries .

Could you please suggest me an idea to achieve this.

Is there any Macros to achieve this?

I am attaching sample QVW also.

Thanks in Advance,

M V

Re: Help on Chart Click

yura_ratu — Thu, 04 Feb 2016 18:44:09 GMT

Hi. Look at the attachment

Re: Help on Chart Click

Sat, 06 Feb 2016 15:01:38 GMT

Hi Yurii,

Thank you very much for reply!

It is working as expected but i have calculated dimensions in my QVW there i'm getting issues.

Is there any macro type of solutions for this?

Thanks,

M V

Re: Help on Chart Click

yura_ratu — Mon, 08 Feb 2016 09:48:20 GMT

Hi,

You can add this aggregation to your calculated dimensions. The issue with macro is it won't be working on full browser version the application