topic excluding a field in a dimension - easy answer? in QlikView

excluding a field in a dimension - easy answer?

Thu, 12 Jan 2012 19:49:01 GMT

Hi collective,

I am building a pivot table and one of the dimensions contains a text string "No abnormalities detected". All I want to do is exclude this statement and any associated data from the pivot table. If it was a set analysis I want the set of everything that was not "No abnormalities detected". Any ideas how to do this?

I am sure its pretty easy but I'm a noob!

excluding a field in a dimension - easy answer?

Anonymous — Thu, 12 Jan 2012 20:03:11 GMT

Hi there,

Try this:

Choose on the dimensions tab: Add calculated dimension.

Type: =if(your_dimension<>'No abnormalities detected', your_dimension)

Make sure you check the box Supress When Value Is Null.

Kind regards,

Henco

excluding a field in a dimension - easy answer?

Thu, 12 Jan 2012 22:48:49 GMT

Of course the good old if expression!

Thanks Henco - apprecated!