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: 
Not applicable

Error with expression

Hi,

A solution was kindly provided to us via the community which when selected just brough through a certain amount of properties meeting the following criteria:

This is on a serach string on a button entitled red properties. The criteria for red is any property with a value less than 4999:

concat({$ <[NPV Total]={"<-£4999"}>} Address, '"' & '|' & '"') & '"' & ')'

It worked to date but now with new data its showing one property as green when the button is selected. Please see attachment on what happens and then how its resolved - but we shouldnt have to additional bits to resolve.

Any help would be appreciated:

Chris

15 Replies
karolina_
Creator II
Creator II

Flag would be much better & quicker & nicer, but with variables it can be like in attached app.

rubenmarin

Hi Chris, I used this expression in 'RED NPV' button action:

=    '(' & '"' & concat({$ <Address={"=Avg([NPV Total])<-4999"}>} Address, '"' & '|' & '"') & '"' & ')'

Not applicable
Author

Thnak very much Karolina. Have both options now to use.

Much appreciated.

Chris

karolina_
Creator II
Creator II

Would that work on different set of data?

Actually it's giving now 135 reds in stead of 136

rubenmarin

True, that's because the address '3 Ciztxx Zfbkm' is in Moss Vale and Mountskip, so filtering only by address will lead to this kind of unexpected results, filters should apply to a key that combines neigbourhood and address to avoid this.

rubenmarin

Maybe changing the action field from Address to UPRN and use this expression:

='(' & '"' & concat({$ <UPRN={"=Avg([NPV Total])<-4999"}>} UPRN, '"' & '|' & '"') & '"' & ')'