topic Re: Limiting rows displayed in a Pivot or Straight table based on a dimension value in QlikView

Limiting rows displayed in a Pivot or Straight table based on a dimension value

Fri, 10 Apr 2015 20:05:14 GMT

Trying to supress a row of data measures based on the value for the dimension. For example, I have three columns of data, the first being a Dimension (FV Level) and the other two (CY Value, PY Value). I believe the way do this is by using the Settings for Selected Dimension:Enable Conditional. I'm unclear on what syntax I need to use when trying to limit. Essentially I want to show rows where the FV Level <> (not equal) to "[NULL]". Any thoughts or ideas?

Re: Limiting rows displayed in a Pivot or Straight table based on a dimension value

Anonymous — Fri, 10 Apr 2015 20:11:36 GMT

Select Properties, tag dimensions the option Suppress When Value is Null

I hope help you!

Re: Limiting rows displayed in a Pivot or Straight table based on a dimension value

Fri, 10 Apr 2015 20:16:18 GMT

Jannet,

Thank you for your prompt response, however, I tried that and realized the value is a text string "[NULL]" and not an actual [NULL] value. The data I'm using is coming straight out of an excel spreadsheet and not a relational database.

Jeff

Re: Limiting rows displayed in a Pivot or Straight table based on a dimension value

Fri, 10 Apr 2015 20:21:33 GMT

Re: Limiting rows displayed in a Pivot or Straight table based on a dimension value

Anonymous — Fri, 10 Apr 2015 20:36:53 GMT

Try,

Add Calculated Dimension,

=if([Fair Value Level]<>'[NULL]',[Fair Value Level])

Re: Limiting rows displayed in a Pivot or Straight table based on a dimension value

Anonymous — Fri, 10 Apr 2015 20:41:06 GMT

The "Settings for Selected Dimension:Enable Conditional" is to either show or hide a dimension completely based on the condition you put in there. If you don't want to show a value from a dimension..

Add a calculated dimension like this instead...

if([Fair Value Level]<>'[NULL]',[Fair Value Level]) and make sure 'suppress when value is null' is checked..

Re: Limiting rows displayed in a Pivot or Straight table based on a dimension value

Fri, 10 Apr 2015 20:47:15 GMT

Thank you both. The formula Jannet provided worked and I did have to select the check box for 'Suppress when value is null'.