topic Re: Dynamic values in the chart while dimesion is drill down group in QlikView

Dynamic values in the chart while dimesion is drill down group

rsdhavle — Tue, 24 Dec 2013 07:11:11 GMT

Hi,

I have created one chart in which i am passing one drill down group as a dimension. Lets say group is BU - Sub BU - Clients

There is another drill down present like BU- Industry - Clients

so in the single chart values can we get option either by drilling down to BU-Sub Bu wise or BU- Industry wise by clicking?

Re: Dynamic values in the chart while dimesion is drill down group

jagan — Tue, 24 Dec 2013 07:21:27 GMT

Hi,

Try Enable Conditional option in Dimension tab of Chart properties, add two groups as dimension on conditional basis enable any one Group by using Variable and Buttons.

Regards,

Jagan.

Re: Dynamic values in the chart while dimesion is drill down group

rsdhavle — Tue, 24 Dec 2013 07:35:03 GMT

Can you give sample expression which should be used in enable condition? for lets say there are two dimesions i am passing A and B

Re: Dynamic values in the chart while dimesion is drill down group

jagan — Tue, 24 Dec 2013 07:40:17 GMT

Hi,

Check this Adhoc reporting in Qlikview, instead of Dimension you use Groups.

If not works for you, Can you attach some sample file?

Regards,

Jagan.

Re: Dynamic values in the chart while dimesion is drill down group

Wed, 25 Dec 2013 13:12:51 GMT

Hi,

Thanks Jagan Mohan,

This Calculation is correct?

GetSelectedCount(_dimension) > 0

Regards,

Raja.