Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Set Analysis Statement

I am sitting here scratching my head.  The following set analysis statement produces an empty string.

=concat({$<CompPoints = {2}>} CompTitle,', ')

The second one produces the string.

=concat({$<CompPoints = {"=2"}>} CompTitle,', ')

2 Replies

What about if you add single quotes around 2 in your first expression

=Concat({$<CompPoints = {'2'}>} CompTitle,', ')

MVP & Luminary
MVP & Luminary

The first one compared CompPoints against a numeric 2 and the second one compared CompPoints against a search-string containing 2. If you used single-quotes like '2' the first expression should be work too, whereby it depends on your release and some settings & when the app was created how the single-quotes are interpreted. More to them could you find here: Quotes in Set Analysis.

Edit: Fields which contain values which could be numeric interpreted should be real numbers - this meant not to use '2' anywhere in the script else just 2 and if it's already stored as string it should be converted with functions like num#().

- Marcus