Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kschul44
Contributor
Contributor

How to use selected item within an expression?

I want to use a selected item in my expression but I am not having any luck.. Here is the expression:

=count(DISTINCT{<Capability_Level=GetFieldSelections(Capability_Level)>} Capability_Number)


The expression works if I hard code the Capability Level to equal a number but I want the users to be able to choose what Capability Level to look at.

2 Replies
devyanshu_gupta
Partner
Partner

Hi Kelly,

You don't need to use a set expression here. A normal filter would work here. Also in set analysis RHS is supposed to be in curly brackets.

Regards,

Devyanshu

balabhaskarqlik

=count(DISTINCT{<Capability_Level={'$(=GetFieldSelections(Capability_Level))'}>} Capability_Number)