Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

matthewp
Contributor III

Using an expression result as a selection

I have a simple straight table that has a dimension and an expression.

The expression either outputs yes or no.

However i cannot select the expression results to only show yes's or only show no's

can this be done?

1 Solution

Accepted Solutions

Re: Using an expression result as a selection

Try creating a list box using this expression:

Aggr(If(Only({1}Numb) - Above(Only({1}Numb)) = 1, 'Match', 'Check'), DimensionsFromYourTableHere)

8 Replies

Re: Using an expression result as a selection

May be like this, to show just yes

If(Expression = 'Yes', Expression)

matthewp
Contributor III

Re: Using an expression result as a selection

in the table or in the list box?

Re: Using an expression result as a selection

If you want to select the 'yes' or 'no' data.. you need to look on calculated dimension

Re: Using an expression result as a selection

What is the expression you are using right now?

jonas_rezende
Valued Contributor

Re: Using an expression result as a selection

Hi, matthewp.

See if the solution in Thread the help - Re: Searching with Set Analysis.

Otherwise, an idea would be use expression in object ListBox.

Ex.:

Aggr(Sum(expression),dimension).


Hope this helps!

Re: Using an expression result as a selection

Try within a listbox:

aggr(YourExpression, YourDimension)

- Marcus

matthewp
Contributor III

Re: Using an expression result as a selection

=IF(Numb-Above(Numb) = 1 ),'Match','Check')

Re: Using an expression result as a selection

Try creating a list box using this expression:

Aggr(If(Only({1}Numb) - Above(Only({1}Numb)) = 1, 'Match', 'Check'), DimensionsFromYourTableHere)

Community Browser