Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Seperating out a specific field from a set of data

Hi there, I hope someone can help...... again!

I have created a chart from following data sources held in a table called "Location_split_perc" giving the values in the chart.

Location Chart.png

I want to create a text box object that pulls in the result from the "Location_split_perc" of only the "office"

How do I seperate out the other data or only select the three items within "Office" which are Desk, Open Space and Room?

Thanks

Rob

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Rob,

You can use set analysis to only focus on one value, in this case 'Office'.

For example, if you want to count the instances of FIELDNAME where Location_split_perc=Office, the expression below would work:

=count({$<Location_split_perc={'Office'}>} FIELDNAME)

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi Rob,

You can use set analysis to only focus on one value, in this case 'Office'.

For example, if you want to count the instances of FIELDNAME where Location_split_perc=Office, the expression below would work:

=count({$<Location_split_perc={'Office'}>} FIELDNAME)

Not applicable
Author

Johannes, that worked after a bit of swapping around and getting the fieldname and Location Split in the right place.

I also used Sum instead of count.

I was wondering how I could show this as a percentage - at the moment I have created a variable:

VarTotOfficeUtil  - which is made up of the calculation below:

=sum({$<response_level2={'Office'}>}Location_split_perc)

And then used that in the Text Object to get the result 0.68

=Num(VarTotOfficeUtil,'#0.00')

Your continued help is appreciated.

Thanks

Rob