Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Evan0211
Creator II
Creator II

Limiting a dataset with a variable input

I have a table that is like this....

Base Fee Incentive Fee
100 -
- 100
500 -
400 -
- 300

etc.

I have created a variable input with three buttons: Show All, Base Fee, Incentive Fee

I am working on the functionality to limit the data now, but I cannot programmatically filter out the nulls for some reason.

I have tried: 

=if(Not isnull(len(trim(BASE_FEE))),BASE_FEE)

=if(not isnull(BASE_FEE), BASE_FEE)

=if(LEN(Trim(BASE_FEE)) > 0, BASE_FEE)

UPDATE: I have added this expression, which will make the null (-) a 0, but I am still unable to filter out the rows where BASE_FEE = 0

=if(Aggr(Alt([BASE_FEE],'0'),BASE_FEE) > 0, BASE_FEE)

I can find the BASE_FEE that is not null, but I cannot filter out the BASE_FEE that is null (which shows in the table as -).  I will wire all of the functionality into a variable once it is working, but for now I am just trying to hardcode to test.

Any ideas?

2 Replies
edwin
Master II
Master II

if BASEFEE is a dim, you can set the ignore null.  if you are are using it as a measure, try if using the modifier BASE_FEE={"*"} will help

edwin
Master II
Master II

BASE_FEE={"*"} will exclude rows with null BASE FEE in your calculation