Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a bar chart and two filters, the dimension is Date concatenated with Status Yes, No, NA. I colored the dimensions bars by using the (Substring) function to color by the Status Yes, No, or NA so I get three colors repeat for each date if concatenated with Yes (Green) If No (Red) if NA (Blue). I fixed the view of the chart by using set analysis to return the count and empty string for the site number to ignore the selections. The problem is when the user uses the site number filter the colors change. I need the colors and the bars to not change even by using the site number filter. I will include the qvw in the attachments. Thanks and regards
I think this should work
See attached
I need to view all the bars and the bars never change when the user make a selection in the site number list box. I can provide more explanation if my explain was not clear. Thanks
Can you explain in more details?
is that better
Thanks for your effort. I need to use the dimension Date_Ins_Status not Date. Thanks again
Hi Walid,
Please find the attachment.
The purpsoe of selecting a site is to display its specific details where we have already broken it be using set analysis, so we can make it show like below
this will tell the user that the black bars are not applicable for the selected site(3 in this example).
Or if u want the site selection not no be effecive anywhere then there is no purpose to have the list box there,
Still fi u need to have the list box there and wan to stay numb u can put it in a different alternate state this will result in below
Hope u know Alternate states. In the attached app i have created an alternate state called without selection and applied it to the list box in the above pic.
Hope this helps.
-Sundar
Thanks for effort. The problem in using the alternate state is that the alternate state will affect the full chart. What I need is, to add effect on only one expression and not the whole chart. So, in this case Alternate state will not be so useful. Any other ideas??
I think this should work
This one Worked. Thank you so much