Limiting an expression in a chart via variable

[cyberclaus]

Hi there,

as a newbe I have a question you sure can answer. I got a view to a database that gives me a set of assets, the installed software Firefox, Notepad++ and 7zip and the respective versions of that tools. My task is to build one page showing three charts, one for every software and versions. But only if the version is old.

AssetName   Tool    Version
Computer1    7ZIP   17
Computer2    7ZIP    18
Computer3    Firefox 60

I created a script, got access to the database and got every single field. I also created three variables (e.g. ZipVersion)  with the wanted software versions of the three tools. But I can't find where I can limit the records for each chart on the specific software and furthermore the relevant version.

A conditional setting at the expression (Count(Assetname)) like this if(Software Like '7-Zip%' and SW_Version <> 'ZipVersion',Assetname) at Expressions has no effect.

Maybe it is very easy but unfortunately I don't see it.

Thank you in advance

Greetz

cyberclaus

[sunny_talwar · Accepted solution]

Try something like this

Count({<Software  = {"7-Zip*"}, SW_Version -= {"$(ZipVersion)"}>}Assetname)

[anushree1]

Please try this 

=count({<Software={"*7-Zip%"},7-Zip%-={'ZipVersion'}>}Assetname)

[anushree1]

I mean

=count({<Software={"*7-Zip%"},SW_Version-={'ZipVersion'}>}Assetname)

[cyberclaus]

Thank you very much - works perfect.