topic Re: Straight Table in QlikView

Straight Table

hkg_qlik — Wed, 10 Apr 2013 21:20:11 GMT

Hi,

I would like to restrict the dimension based on the outcome of a Expression.

For example:

Account ID Member ID Program Name Projected Cost Actual Cost Variance (Projected - Actual)

100 1000 ABC 1000.00 1000.00 0.00

200 2000 XYZ 2000.00 1000.00 1000.00

In the above scenario all the second record should be visible to the user as it has variance. rest all with 0 variance should be hidden from the table.

Thanks,

--Please look at the file attached for better visibilty of the question--

Re: Straight Table

Thu, 11 Apr 2013 12:03:39 GMT

On the chart properties go to the “presentation” tab and select “Suppress Zero Values”

Re: Straight Table

MarcoARaymundo — Thu, 11 Apr 2013 15:39:43 GMT

try this

aggregation function ({<variance={'>0'}>} variance)

Re: Straight Table

Thu, 11 Apr 2013 15:58:45 GMT

Perhaps this will work:

Projected cost = sum(if(variance >0, [Projected Cost]))

Actual cost = sum(if(variance >0, [Actual Cost]))

Another option avoiding an if could be:

Projected cost = sum({<variance = {'>0'}>} [Projected Cost]))

Actual cost = sum({<variance = {'>0'}>} [Actual Cost]))

Hope one of these methods help.

Best,

Matt

Re: Straight Table

Fri, 12 Apr 2013 14:20:48 GMT

Did any of the options above work for you?

Matt

Re: Straight Table

Fri, 12 Apr 2013 15:02:45 GMT

Hi,

Try to keep the Project Cost and Actual Cost in the Dimension .

Just Keep ProjectCost - Actual Cost (Variance) in the Expression .

So it will automatically hide when the Expression ( Variance values ) is Zero .

Thanks

Please let me know for the same .