topic Set Analysis - specific value in QlikView

Set Analysis - specific value

Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

In the list box page_storytellers_by_city_sub_name (image below) i want to create expression of all city from Noord-Holland.

my current expression is =sum({$<page_storytellers_by_city_sub_name= {"Noord-Holland"}>}page_storytellers_by_city_value)

when i use this expression in the text object the value returns into 0. Which expression should i use?

Thank u so much!

Greets,

Rega

sunny_talwar — Mon, 25 Apr 2016 12:29:45 GMT

What about this:

=Sum({$<page_storytellers_by_city_sub_name= {"*Noord-Holland*"}>}page_storytellers_by_city_value)

Mon, 25 Apr 2016 13:05:50 GMT

Hey Sunny T,

And how about a expression to get result all city exclude "*Netherlands*"?

Thanks

trdandamudi — Mon, 25 Apr 2016 13:32:23 GMT

May be like below:

=Sum({$-1 <page_storytellers_by_city_sub_name= {"*Netherlands*"}>}page_storytellers_by_city_value)

sunny_talwar — Mon, 25 Apr 2016 13:35:11 GMT

May be this:

=Sum({$<page_storytellers_by_city_sub_name -= {"*Netherlands*"}>}page_storytellers_by_city_value)

Note a small negative sign before the equal sign