Need table of excluded values

Anonymous — Wed, 12 Aug 2015 21:16:11 GMT

Hello!

I have a straight table that reports Dim1, Dim2 and Dim3 with Expression1. All of these are just fields. When making a selection in a list box, this table shows records that have that list box value.

What I want to do is report the same Dim1, Dim2 and Dim3 with Expression1 but display records that do not have that list box value.

I can get a list box of Dim2 by using this expression:

MaxString({1-$<[Dim2]={'*'}>} [Dim2])

My problem is that when I add Dim1 and Dim3, they are null values. These are the same Dimensions as original straight table, but when I apply the MaxString expression, all the dimensions return a Null Value.

Any ideas on how I can show the excluded values and have the same dimensions?

Thank you,

Lisa

Re: Need table of excluded values

Digvijay_Singh — Wed, 12 Aug 2015 21:54:07 GMT

Something like this?

topic Need table of excluded values in QlikView

Need table of excluded values

Re: Need table of excluded values