Solved: Negitives in Straight Table - Qlik Community

Report Inappropriate Content · ‎2013-10-04

Is there a way to limit a straight table to show only the negative results from an expression within the straight table?

Update with more details....

I have the following expressions:

Yr Potential Pay Impact: If(Target-[Adjusted Actual]<0,Target-[Adjusted Actual],0)

Target: WorkRVU+[Contract RVUs])*Multiplier)/[Month Number])*12

Adjusted Actual: Wage-Wage_Admin

There is also a flag to say if an employee has been with the company for 2 years

What I need to show in a straight table is only the employees whose [Yr Potential Pay Impact] <0 AND 2yr_Flag =No

Sorry for the poorly spelled out first attempt at a question, apparently my brain thinks its already the weekend!

Thanks for your help!

bbi_mba_76 · ‎2013-10-04

I loaded this table

where we have a dimension Dim, a flag, a measure and Abs to calculate negative values.

Using a calculated dimension I apply the first filter

Then I use the dimension limits

View solution in original post

rustyfishbones · ‎2013-10-04

Do it in the expression.

Like SUM(Sales) > 0

Report Inappropriate Content · ‎2013-10-04

LOL... thanks, I don't think I explained myself well. I might have to think about it and explain my question a little better

bbi_mba_76 · ‎2013-10-04

You could use an if in the expression and suppress the dimension when value is null

=if(sum(Sales)<0, sum(Sales)

rustyfishbones · ‎2013-10-04

ha! no problem.

I had the Expression wrong anyway

it should be

< 0

srchilukoori · ‎2013-10-04

use the expression:

IF(Sum(<Value>) < 0, Sum(<Value>), 0)

and suppress the zero values in the presentation tab.

bbi_mba_76 · ‎2013-10-04

You could use a calculated dimension to filter the rows you need and then hide this column in the presentation tab.

Report Inappropriate Content · ‎2013-10-04

I have tried similar logic but I keep getting error messages from QlikView.

The expression I have entered is:

((Sum([Yr Potential Pay Impact])<0) and (Hire_Age='New'),[Yr Potential Pay Impact],0)

When including the expression and field names I am using the prepopulated drop down and I am getting a 'Bad Field Name Error' on Yr Potential Pay Impact. I don't understand how its a bad field name if I am selecting it out of the list?!

Report Inappropriate Content · ‎2013-10-04

QlikView is not allowing me to use the Expression Name in a calculated Dimension

bbi_mba_76 · ‎2013-10-04

I suppose first you have to define the dimension and then the expressions in a chart.

If I understand well Yr Potential Pay Impact, Target and Adjusted Actual are the expressions you defined in the straight table, so they are not available as calculated dimension.