Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kicchu465
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
MarcoWedel

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

MK_QSL
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)

shiveshsingh
Master
Master

Try putting a * sign before = in set analysis

Sum({<Dim *=