Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

rammuthiah
Contributor II

How to display table based on measures greater than certain value

Pipeline

Measure(count of register)

Value
158
296
3611
431

I want to display Value column based on the count of register that are greater than 6. It shouldn't show others.

Expected Output :

PipelineValue
26
311
1 Solution

Accepted Solutions
MVP
MVP

Re: How to display table based on measures greater than certain value

A static value of 6? Or is that derived in some way?

     Dimension: Pipeline

     Expression: =If(... expression for measure ... > 6, Value)

5 Replies
MVP
MVP

Re: How to display table based on measures greater than certain value

A static value of 6? Or is that derived in some way?

     Dimension: Pipeline

     Expression: =If(... expression for measure ... > 6, Value)

Re: How to display table based on measures greater than certain value

Why is Pipeline 8 excluded here? The value is 8 and above 6?

rammuthiah
Contributor II

Re: How to display table based on measures greater than certain value

Is there any way to show the details greater than 6. While adding

Dimensions, it shows as null for lesser or equal to 6 based on measure. I

don't need to show the null values.

On Mon, Jun 20, 2016 at 7:07 PM, Jonathan Dienst <qcwebmaster@qlikview.com>

rammuthiah
Contributor II

Re: How to display table based on measures greater than certain value

Value should display based on Measure(count of register) >6

marinasbc
New Contributor III

Re: How to display table based on measures greater than certain value

Hi,

You should use set analysis like:

Expression "Value" with Sum({< Pipeline = {"=MeasureWithCountOfRegisterExpression>6 "} >}Value)

Community Browser