Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Set analysis based on value of a field in a straight table

Below is a sample of my data set:

Metric 110%
Metric 220%
Metric 1 #50
Metric 2 #20

You'll notice that there are 2 metrics with a percentage value and 2 with a numeric value.  The % metrics and # metrics are related to each other.

I have a straight table where I was to display the % metrics along with the # metric value in parenthesis

for example

Metric 110% (50)
Metric 220% (20)

I can easily create the straight table with the Metric and the % value but I can't seem to zero in on the correct syntax for the set analysis for the portion in parenthesis.  This formula should be based on the metric name plus the "#". 

One more added complexity, I want all of the values to show in the straight table at all times regardless if someone happens to click on one of the metrics (so it basically needs to ignore the current selections as part of the set analysis).

Hoping this is enough to go on for someone.  I don't have a simple version of my application to share as this time.



4 Replies
Not applicable

Hi Bronson,

you can use the concat function to achieve this, please see attached

hope that helps


Partner - Contributor III
Partner - Contributor III

Not sure that's going to work because the sample I gave is very simplistic.  The real data is much bigger with a few other elements to the data such as Country, etc.  So the numeric value would need to be aggregated.  Does that change the answer?

Not applicable

Yes it most likely would, helpful if you could upload an example or provide a bit more basic data to work with


Specialist III
Specialist III

you do know that the best way to do this is to modify your backend and instead of having "metric #" and metric have a value and a value %  and then just concatenate the values