Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bronsonelliott
Partner
Partner

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

Below is a sample of my data set:

MetricValue
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

MetricValue
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.

Thanks!

Bronson

4 Replies
Not applicable

Hi Bronson,

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

hope that helps

Joe

bronsonelliott
Partner
Partner
Author

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

thanks

ramoncova06
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