Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hkg_qlik
Creator III
Creator III

Straight Table

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,

H

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

5 Replies
Not applicable

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

MarcoARaymundo
Creator III
Creator III

try this

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

Not applicable

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

Not applicable

Did any of the options above work for you?

Matt

Not applicable

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 .