Dynamic showing of the Expressions(KPIs)

[dmohanty]

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

[#2]

Can you post your .qvw file.

So it would be easy for us to understand the requirement.

[tresesco]

Try this expression:

=GetSelectedCount(Region)>1

[antoniotiman]

Try

SubStringCount(Concat(_Region,'|'),'USA') in condition

for each column with 'USA,'IND',  selected in list box.

Regards

[dmohanty]

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?

[tresesco · Accepted solution]

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.

[jagan]

Hi,

Try like this

=GetSelectedCount(Region) > 0

Also check below link, hope it helps you.

Adhoc reporting in Qlikview

Regards,

Jagan.

[dmohanty]

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