Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
cyberclaus
New Contributor

Limiting an expression in a chart via variable

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

 

 

 

 

1 Solution

Accepted Solutions

Re: Limiting an expression in a chart via variable

Try something like this

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

Re: Limiting an expression in a chart via variable

Try something like this

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

Re: Limiting an expression in a chart via variable

Please try this 

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

anushree1
Valued Contributor

Re: Limiting an expression in a chart via variable

I mean

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

cyberclaus
New Contributor

Re: Limiting an expression in a chart via variable

Thank you very much - works perfect.