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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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