Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

Dynamic showing of the Expressions(KPIs)


Hi All,

Could some one please show me how to implement the below requirement?

I have a chart/report like this below:

IDNameCount of Sales (IND)Count of Sales (USA)Count of Sales (JPN)Count of Sales (CAN)
1A10015080120
2B10015080120
3C10015080120
4D10015080120
5E10015080120

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Dynamic showing of the Expressions(KPIs)

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.

View solution in original post

7 Replies
Not applicable

Re: Dynamic showing of the Expressions(KPIs)

Can you post your .qvw file.

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

MVP
MVP

Re: Dynamic showing of the Expressions(KPIs)

Try this expression:

=GetSelectedCount(Region)>1

antoniotiman
Honored Contributor III

Re: Dynamic showing of the Expressions(KPIs)

Try

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

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

Regards

Partner
Partner

Re: Dynamic showing of the Expressions(KPIs)

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?

MVP
MVP

Re: Dynamic showing of the Expressions(KPIs)

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.

View solution in original post

MVP & Luminary
MVP & Luminary

Re: Dynamic showing of the Expressions(KPIs)

Hi,

Try like this

=GetSelectedCount(Region) > 0


Also check below link, hope it helps you.

Adhoc reporting in Qlikview


Regards,

Jagan.

Partner
Partner

Re: Dynamic showing of the Expressions(KPIs)


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