Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Primrose
Contributor III
Contributor III

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?

Labels (3)
1 Solution

Accepted Solutions
PV
Contributor II
Contributor II

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

View solution in original post

1 Reply
PV
Contributor II
Contributor II

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

View solution in original post