topic Selections in a BarChart in QlikView

Selections in a BarChart

kicchu465 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have a requirement as below, Could you please help me in getting this done.

I have created a bar chart with Dimension and measure as below.

Dimension Name : Dim

Measure :sum({<Dim={'Rev_Mobility','Rev_Fixed_Connectivity_Access','Rev_Cloud_Hosting','Rev_M2M_Services','Rev_One_Net','Rev_Professional_Services'}>}Measure)

The bar Chart looking like as below.

The issue is when I clik on any of the Dimension on the bar chart it is displaying all the Dimesions irrespective of the selection but I need is, when I click on any of the bar the chart has to display only that particular Dimesion.

Thanks

Re: Selections in a BarChart

MarcoWedel — Sat, 19 May 2018 22:10:01 GMT

Hi,

you could change your expression to something like

Sum({<Dim=p(Dim)*{'Rev_Mobility','Rev_Fixed_Connectivity_Access','Rev_Cloud_Hosting','Rev_M2M_Services','Rev_One_Net','Rev_Professional_Services'}>}Measure)

Sum({$*<Dim={'Rev_Mobility','Rev_Fixed_Connectivity_Access','Rev_Cloud_Hosting','Rev_M2M_Services','Rev_One_Net','Rev_Professional_Services'}>}Measure)

hope this helps

regards

Marco

Re: Selections in a BarChart

MK_QSL — Sun, 20 May 2018 08:36:26 GMT

You can try this one as well.

Sum({<Dim *={'Rev_Mobility','Rev_Fixed_Connectivity_Access','Rev_Cloud_Hosting','Rev_M2M_Services','Rev_One_Net','Rev_Professional_Services'}>}Measure)

Re: Selections in a BarChart

shiveshsingh — Sun, 20 May 2018 09:17:30 GMT

Try putting a * sign before = in set analysis

Sum({<Dim *=