Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Please visit COVID-19 group to keep up the discussion. GO TO GROUP
New Contributor

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
New 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),',')