Discussion Board for collaboration related to QlikView App Development.
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
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)
hope this helps
regards
Marco
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)
Try putting a * sign before = in set analysis
Sum({<Dim *=