topic Re: Dynamic showing of the Expressions(KPIs) in QlikView

Dynamic showing of the Expressions(KPIs)

dmohanty — Tue, 15 Apr 2014 06:51:52 GMT

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

Re: Dynamic showing of the Expressions(KPIs)

Tue, 15 Apr 2014 06:57:49 GMT

Can you post your .qvw file.

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

Re: Dynamic showing of the Expressions(KPIs)

tresB — Tue, 15 Apr 2014 07:00:23 GMT

Try this expression:

=GetSelectedCount(Region)>1

Re: Dynamic showing of the Expressions(KPIs)

antoniotiman — Tue, 15 Apr 2014 07:08:42 GMT

Try

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

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

Regards

Re: Dynamic showing of the Expressions(KPIs)

dmohanty — Tue, 15 Apr 2014 08:55:28 GMT

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?

Re: Dynamic showing of the Expressions(KPIs)

tresB — Tue, 15 Apr 2014 10:21:43 GMT

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.

Re: Dynamic showing of the Expressions(KPIs)

jagan — Tue, 15 Apr 2014 10:30:32 GMT

Hi,

Try like this

=GetSelectedCount(Region) > 0

Also check below link, hope it helps you.

Adhoc reporting in Qlikview

Regards,

Jagan.

Re: Dynamic showing of the Expressions(KPIs)

dmohanty — Tue, 15 Apr 2014 10:56:47 GMT

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