topic Re: Values on selections in QlikView

Values on selections

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have the data like:

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

swuehl — Thu, 19 May 2016 12:48:47 GMT

Maybe like

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

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

Thu, 19 May 2016 12:55:32 GMT

Hi swuehl,

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

swuehl — Thu, 19 May 2016 13:14:00 GMT

It's working for me.

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

Thu, 19 May 2016 13:16:19 GMT

Thanks swuehl,

The second one worked for me.

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

Regards,

Anjali Gupta