Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a chart as below :
A,B and C are the KPI's in which A is in Blue Color , B is in Yellow Color and C is in Red colour. I have a list box where there are Person names in that. When i click on any person name :
1)I should get only A and B i.e Blue and Yellow colors and not red color(I am able to accomplish this by using getselectedcount(person)=0 in the conditional statement of the C kpi )
2)When i click on "NLL" value in Person list box i must get only C value i.e only red colour .
Am unable to get the 2nd condition mentioned above. Is it possible to filter for the values in the same list box multiple times ?
Pls let me know how to achieve this.
Thanks
Maybe add a second condition to the red expression conditional:
=getselectedcount(person)=0 or Only(person) = 'NLL'
and also add conditional to the expression for blue and yellow:
=Only(person) <> 'NLL'
swuehl could you pls help on this
stalwar1 could you pls help out with the above query I have
Is there a qvw file you can share where we can see the set up you have?
Maybe add a second condition to the red expression conditional:
=getselectedcount(person)=0 or Only(person) = 'NLL'
and also add conditional to the expression for blue and yellow:
=Only(person) <> 'NLL'
thank you Stefan. It worked !