Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Straight Table Conditional Show Expression

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

Tags (1)
1 Solution

Accepted Solutions

Re: Straight Table Conditional Show Expression

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

View solution in original post

4 Replies

Re: Straight Table Conditional Show Expression

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

View solution in original post

Re: Straight Table Conditional Show Expression

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

Re: Straight Table Conditional Show Expression

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

Not applicable

Re: Straight Table Conditional Show Expression

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