Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
kicchu465
Contributor

Selections in a BarChart

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

3 Replies

Re: Selections in a BarChart

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)

or

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

QlikCommunity_Thread_301976_Pic1.JPG

QlikCommunity_Thread_301976_Pic2.JPG

QlikCommunity_Thread_301976_Pic3.JPG

QlikCommunity_Thread_301976_Pic4.JPG

QlikCommunity_Thread_301976_Pic5.JPG

hope this helps

regards

Marco

MVP
MVP

Re: Selections in a BarChart

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)

shiveshsingh
Honored Contributor

Re: Selections in a BarChart

Try putting a * sign before = in set analysis

Sum({<Dim *=