Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

Extract data from selection

Hi

 

I'm using a calculation that counts the number of customers that bought a category.  When I'm selecting the category I select the "name" but internaly I'm using an ID.

How could I extract this id and put it in a variable? to use it in another graph with another calculations....

there is something like "value selected in X field"?

Thanks

Labels (1)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

You should be able to get the id. but there are multiple approaches.

1- If a single value you can use expression like Only(ID)

2- Multiple values - you can get full selections through concat(ID) function or you can use p(ID) in set analysis 

p function details can be found in this thread. please note p() function is possible within set analysis only

https://community.qlik.com/t5/QlikView-App-Development/P-E-and-where-do-you-use-them/td-p/457847

 

View solution in original post

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

You should be able to get the id. but there are multiple approaches.

1- If a single value you can use expression like Only(ID)

2- Multiple values - you can get full selections through concat(ID) function or you can use p(ID) in set analysis 

p function details can be found in this thread. please note p() function is possible within set analysis only

https://community.qlik.com/t5/QlikView-App-Development/P-E-and-where-do-you-use-them/td-p/457847