topic Re: Limit on Expression in QlikView

Limit on Expression

Thu, 09 May 2013 15:23:46 GMT

I have table with dimensions DATE and Company. Expressions are: TOTAL LOSS and CHANGE.

At the moment all the data is being displayed but I only need to display rows where CHANGE is not < 50%. This way I should only have rows where data's missing or CHANGE is over 50% left.

Any ideas how to do it?

Re: Limit on Expression

Anonymous — Thu, 09 May 2013 15:38:02 GMT

You can restrict the dimenion with the definition of CHANGE expression < 50%.

E.g. Create a calculated dimenion with the name Company and IF(CHANGE_formula <50%, Company, '').

So only values of the Company dimension that satisfies CHANGE <50% will be displayed!

Regards

MultiView

Re: Limit on Expression

Thu, 09 May 2013 15:45:39 GMT

I tried this and get Error in calculated dimension message.

Also, I need values that are NOT < 50% otherwise missing values would be excluded. My goal is to display all the missing values and the ones that are over 50%

Re: Limit on Expression

Anonymous — Thu, 09 May 2013 15:57:09 GMT

Could you upload the app with sample data?

Regards

MultiView

Re: Limit on Expression

Thu, 09 May 2013 16:21:13 GMT

uploaded a sample app with some sample data in the main question thanks

I tried using aggr() with an if statement and sum() but still nothing

Re: Limit on Expression

Mon, 13 May 2013 09:51:38 GMT

Updated the file, I only need to display value where NullCheck = 1.

Would it be possible to use calculated dimension to solve this?

if (

aggr(sum(LOSS)-above(sum(LOSS))/above(sum(LOSS)) <= -0.5,MEMBER_NAME) , MEMBER_NAME,0)

This doesn't display the needed results, should I be using AGGR()?

Just added checks for all the dimensions and seemed to work this time.