Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
sunny_talwar

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
sunny_talwar

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

Kushal_Chawda

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

sunny_talwar

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

Not applicable
Author

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