Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Values on selections

Hi Experts,

I have the data like:

NameValue

A

6
B0
C5
D0
E0
F4

I have created a list box with value Name,

My requirement is that when Name = A or B or C is selected, value should be 'NA' or

if the Name selected is (A and B) or (A and C) or (B and C) , value should be 'NA' or

Name is A and B and C , value should be 'NA'


else it should display sum(Value)

PS: I don't want to put so many if conditions. Is there any easy or short way to handle this?

Regards,

Anjali Gupta

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like

If( Count({<Name *= {D,E,F}>} Name), Sum(Value), 'NA')

or

If( Count({<Name -= {A,B,C}>} Name), Sum(Value), 'NA')

View solution in original post

4 Replies
swuehl
MVP
MVP

Maybe like

If( Count({<Name *= {D,E,F}>} Name), Sum(Value), 'NA')

or

If( Count({<Name -= {A,B,C}>} Name), Sum(Value), 'NA')

Not applicable
Author

Hi swuehl,

This is not working. It is showing sum(Value) as 0, instead i want 'NA'.

swuehl
MVP
MVP

It's working for me.

Seems like I have't fully understood your setting according the information provided.

Not applicable
Author

Thanks swuehl,

The second one worked for me.

If( Count({<Name -= {A,B,C}>} Name), Sum(Value), 'NA')

Regards,

Anjali Gupta