Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis in Text Object for string

Hello,

I would like to know if it is possible to use a set analysis restriction in a text object but without any expression.

In another words: usually the set analysis is made with a expression like: count, max, aggr, sum, etc and the respective restrictions.

I want to use a set analysis without the expression because I want to show a string and not a value, but I need the restrictions that a set analysis provides me.

Any thoughts?

Thank you.

Best regards.

Ivo Marques

Labels (1)
10 Replies
stigchel
Partner - Master
Partner - Master

No, but you can use a search string e.g.

Sum({<Customer={"=Mid(Customer,1,1)='A'"}>} Sales)

in your example

=maxstring({<TestArea={'ASD'},KNR={"=mid(KNR,3,1)='7'"},Description-={'Not valid values:'},Results-={'0'}>} Description)