0

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

=If(Only({1}YOURFIELD) - Above(Only({1}YOURFIELD)) = 1, 'Match', 'Check')

The expression either outputs Match or Check.

However I cannot select the expression results to only show Match or Check with the results.

Matt
  • 14,906
  • 27
  • 99
  • 149

1 Answers1

-1

This can be done by creating a list box using this expression:

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

Small Edit to show EldadT how this works:

enter image description here

Matt
  • 14,906
  • 27
  • 99
  • 149
  • stop posting wrong answers. this will not work in a list box! the correct way will probably be to create a field that holds these values. – EldadT Jun 14 '19 at 09:12
  • @EldadT It does work, as it worked for me, hence the answer – Matt Jun 14 '19 at 10:24
  • the above function cannot work in a list box...but...whatever – EldadT Jun 14 '19 at 11:41
  • @EldadT Once again. Yes it does, i made you a video showing it :) (click on it to make it full screen) – Matt Jun 14 '19 at 14:21
  • just read the help: https://betahelp.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctions/InterRecordFunctions/above.htm it says that it only works in a column table... – EldadT Jun 14 '19 at 19:01
  • try without the above function - do you should get the same result? – EldadT Jun 16 '19 at 11:12