Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted

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

Highlighted
MVP
MVP

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)

Highlighted
Master
Master

Try putting a * sign before = in set analysis

Sum({<Dim *=