Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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