Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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

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)