topic Re: Limiting an expression in a chart via variable in QlikView

Limiting an expression in a chart via variable

cyberclaus — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Limiting an expression in a chart via variable

sunny_talwar — Mon, 11 Feb 2019 13:36:47 GMT

Try something like this

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

Re: Limiting an expression in a chart via variable

anushree1 — Mon, 11 Feb 2019 13:43:01 GMT

Please try this

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

Re: Limiting an expression in a chart via variable

anushree1 — Mon, 11 Feb 2019 13:44:06 GMT

I mean

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

Re: Limiting an expression in a chart via variable

cyberclaus — Mon, 11 Feb 2019 14:18:10 GMT

Thank you very much - works perfect.