Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there. I am trying to achieve a graph, where even when fields are selected, the bars do not disappear, but simply change colors.
Have attached the image on what I have currently, and what I want, to explain in more details.
I have tried adding under expressions background color:
if(GetSelectedCount(Field1) OR GetSelectedCount(Field2),
if(len(concat(Field2)), RGB(200,150,150), RGB(220, 220, 220)), RGB(195, 140, 150))
However, the unselected bars will still disappear.
Any idea what should i do to get the desired outcome?
Thank you!
Kim
Use the same set analysis in your calculated dimension as well, like:
=aggr({$<Class=, Student=>}
subfield(class(
$(=_Z_Formula)
, $(=_Z_Bin)), ' <', 1)
, Student)
Use set analysis in your main expression/measure, like:
Sum({<FieldOfSelection>} Sales)
and then background color expression like:
=If(FieldOfSelection=FieldOfSelection, <selection color>, < light color>)
Hi Treseco,
I've tried that but doesn't seem to work.
Have attached my qvw on this graph with sample excel.
Able to guide me on where did I go wrong?
Thanks!
Kim
Use the same set analysis in your calculated dimension as well, like:
=aggr({$<Class=, Student=>}
subfield(class(
$(=_Z_Formula)
, $(=_Z_Bin)), ' <', 1)
, Student)
Thank you!
It works!