topic Re: Straight Table Conditional Show Expression in QlikView

Straight Table Conditional Show Expression

Fri, 22 Apr 2016 13:43:38 GMT

I am working with a straight tables that has a number of expressions. I want to do a conditional show on the individual expression when a user selects one or more from the %PickMetric below that are shown in a list box within the UI.

DateSelection:

Load * Inline [

%PickMetric, Desc.

1, Prev Month Sums

2, Prev Month GP

3, Prev Month GP %

4, Prev 3 Month Sums

5, Prev 3 Month GP

6, Prev 3 Month GP %

7, Prev 12 Month Sums

8, Prev 12 Month GP

9, Prev 12 Month GP %

10, LTD Sum

11, LTD GP

12, LTD GP %

13, Net Book Value

14, Unit Count

15, LTD CPM

16, Rated CPM

17, Months In Service

18, Remaining Term

19, Miles

20, Spec

21, Customer #

];

The current equation I am using that is not working is;

=IF(GetSelectedCount(%PickMetric) > 0,WildMatch(Concat(%PickMetric),'*1*')>0,0)

Any assistance on this would be much appreciated.

Thanks

Re: Straight Table Conditional Show Expression

sunny_talwar — Fri, 22 Apr 2016 14:25:57 GMT

May be this for the expression for

Prev Month Sums:

GetSelectedCount(#PickMetric) > 0 and SubStringCount(Concat(DISTINCT '|'& %PickMetric &'|'), '|1|') = 1

Prev Month GP:

GetSelectedCount(#PickMetric) > 0 and SubStringCount(Concat(DISTINCT '|'& %PickMetric &'|'), '|2|') = 1

and so on...

Re: Straight Table Conditional Show Expression

Kushal_Chawda — Fri, 22 Apr 2016 14:28:36 GMT

What if user selects the %PickMetric 1 and 10 both at a same time?

Re: Straight Table Conditional Show Expression

sunny_talwar — Fri, 22 Apr 2016 14:30:51 GMT

I don't see the problem if they pick 1 and 10. Expression 1 and 10 will be active.

Re: Straight Table Conditional Show Expression

Fri, 22 Apr 2016 15:04:31 GMT

Works great! No problems when 1 and 10 are selected. Thank you for your help.