topic Sum if in QlikView

Sum if

Anonymous — Thu, 20 Apr 2017 14:23:00 GMT

Hi all,

i have a question and need your help.

I have a list box:

Now I would like to show only Munich.

Is this possible in the properties og the listbox

can i solve it with a textbox like: =sum(Analysen) if Field1 = Munich

Thank you for helping!

sunny_talwar — Thu, 20 Apr 2017 14:28:20 GMT

May be this

=Sum({<Field1 = {'Munich'}>}Analysen)

CathyRDuvall — Thu, 20 Apr 2017 14:37:38 GMT

If you want to maintain using the 'if statement' you would write it as:

sum(if(Field1 = 'Munich', Analysen)