Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner - Specialist
Partner - Specialist

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
tresesco
MVP
MVP

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

Can you post your .qvw file.

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

tresesco
MVP
MVP

Try this expression:

=GetSelectedCount(Region)>1

antoniotiman
Master III
Master III

Try

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

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

Regards

dmohanty
Partner - Specialist
Partner - Specialist
Author

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

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
Luminary Alumni
Luminary Alumni

Hi,

Try like this

=GetSelectedCount(Region) > 0


Also check below link, hope it helps you.

Adhoc reporting in Qlikview


Regards,

Jagan.

dmohanty
Partner - Specialist
Partner - Specialist
Author


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