Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
cyberclaus
Not applicable

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

Re: Limiting an expression in a chart via variable

Try something like this

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

Re: Limiting an expression in a chart via variable

Try something like this

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

Re: Limiting an expression in a chart via variable

Please try this 

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

anushree1
Not applicable

Re: Limiting an expression in a chart via variable

I mean

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

cyberclaus
Not applicable

Re: Limiting an expression in a chart via variable

Thank you very much - works perfect.