Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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: 
Krish
Contributor III
Contributor III

Set Analysis subset selection issues

I have a set analysis for a text object to calculate sum of all employees starting with 4.

sum({<empid={"4*"}>}sal)

But when a particular emp id like 4000 is selected, that is not showing for 4000 and still showing for all employees with 4.

How to achieve this.

 

Labels (1)
1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

You'll want to use an * before the equal sign to create an intersection between the currently available empids and the criteria specified in the set analysis, like this:

sum({<empid*={"4*"}>}sal)

View solution in original post

3 Replies
GaryGiles
Specialist
Specialist

You'll want to use an * before the equal sign to create an intersection between the currently available empids and the criteria specified in the set analysis, like this:

sum({<empid*={"4*"}>}sal)

View solution in original post

Anil_Babu_Samineni

I agree with @GaryGiles here, But you can still try multiplying with dummy row alike.

sum({<empid={"4*"}>}sal)*Sum({$} 1)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Krish
Contributor III
Contributor III
Author

Works perfectly. Thank you!!