Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

walidhussein
Contributor

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
Contributor III

Re: Re: Coloring dimension dispite using filters

I think this should work

9 Replies
iktrayanov
Contributor III

Re: Coloring dimension dispite using filters

See attached

walidhussein
Contributor

Re: Coloring dimension dispite using filters

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
Contributor III

Re: Coloring dimension dispite using filters

Can you explain in more details?

iktrayanov
Contributor III

Re: Re: Coloring dimension dispite using filters

is that better

walidhussein
Contributor

Re: Coloring dimension dispite using filters

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

sundarakumar
Valued Contributor II

Re: Coloring dimension dispite using filters

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

walidhussein
Contributor

Re: Coloring dimension dispite using filters

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
Contributor III

Re: Re: Coloring dimension dispite using filters

I think this should work

walidhussein
Contributor

Re: Coloring dimension dispite using filters

This one Worked. Thank you so much

Community Browser