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: 
Anonymous
Not applicable

Coloring dimension dispite using filters

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

1 Solution

Accepted Solutions
iktrayanov
Creator III
Creator III

I think this should work

View solution in original post

9 Replies
iktrayanov
Creator III
Creator III

See attached

Anonymous
Not applicable
Author

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

iktrayanov
Creator III
Creator III

Can you explain in more details?

iktrayanov
Creator III
Creator III

is that better

Anonymous
Not applicable
Author

Thanks for your effort. I need to use the dimension Date_Ins_Status not Date. Thanks again

sundarakumar
Specialist II
Specialist II

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

topost.PNG

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

topost1.PNG

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

Anonymous
Not applicable
Author

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??

iktrayanov
Creator III
Creator III

I think this should work

Anonymous
Not applicable
Author

This one Worked. Thank you so much