Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
Showing results for 
Search instead for 
Did you mean: 

Presenting calcucalted dimension as text

Hi all,

I have a table where I have a calculated dimension and it works fine. However I have a request to show the same information on one line (as a variable). The variable should be used in NPrinting reports and should be presented as a text. The variable should be something like this:

If (Date=today AND Sum(condition1)<X AND Sum(condition2)>Y), to be displayed list of all people for which this set of conditions is true.

I have limited access to the back end so I'm looking for a front-end solution. I tried different ways to make this, however I nothing works for me. I'm failing to find a way to display only the people that satisfy the above.

Do you have any ideas?

1 Reply
Contributor II
Contributor II

Re: Presenting calcucalted dimension as text

May be something like below
=concat(aggr( Only({<Name={"=sum(Sales1)>25 and Date=today() and sum(Sales2)>15 "}>}Name),Name),',')