Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Could some one please show me how to implement the below requirement?
I have a chart/report like this below:
ID | Name | Count of Sales (IND) | Count of Sales (USA) | Count of Sales (JPN) | Count of Sales (CAN) |
1 | A | 100 | 150 | 80 | 120 |
2 | B | 100 | 150 | 80 | 120 |
3 | C | 100 | 150 | 80 | 120 |
4 | D | 100 | 150 | 80 | 120 |
5 | E | 100 | 150 | 80 | 120 |
I have a List Box for Region having values: IND, USA, JPN, CAN
Whenever I would select any value from the Region list box, that KPI should show up in the chart. Suppose, I select IND and JPN: only KPI 1st and 3rd should show (rest 2 won't show). If I select only CAN, last KPI should show... like this.
I understand that we have to put Conditional Statement in Presentation Tab, but unable to figure out . I tried to put
GetFieldSelections(Region) , but that is working when I select a single value.
I want my chart to work when I select multiple values from Region list box. Please some one help me in this.
Regards!!
This?
=GetSelectedCount(Region)
Update1: was going through your base question. I am not sure about exact requirement. Please share your sample qvw.
Update2: Probably, you are using separate expressions for different countries, if so, use conditional expression (expression tab). Expression would be something like: = Index(GetFieldSelections(Region), 'USA') //for expression USA, and similarly for others as well.
Can you post your .qvw file.
So it would be easy for us to understand the requirement.
Try this expression:
=GetSelectedCount(Region)>1
Try
SubStringCount(Concat(_Region,'|'),'USA') in condition
for each column with 'USA,'IND', selected in list box.
Regards
Hi Tresesco,
Thank you for the help.
However, If I select more than one value from Region List Box, this condition is working fine. If I select a single value from Region List Box, its not working.
COuld you please help more?
This?
=GetSelectedCount(Region)
Update1: was going through your base question. I am not sure about exact requirement. Please share your sample qvw.
Update2: Probably, you are using separate expressions for different countries, if so, use conditional expression (expression tab). Expression would be something like: = Index(GetFieldSelections(Region), 'USA') //for expression USA, and similarly for others as well.
Hi,
Try like this
=GetSelectedCount(Region) > 0
Also check below link, hope it helps you.
Regards,
Jagan.
Thank you very much for the Updates and help on this.
I was about to post a sample QVW, but your UPDATE 2 helped to solve my issue. You have understood my requirement correctly. YES, I have different expressions for each Region.
Thanks a lot again!!!