topic Re: conditional sum in QlikView

conditional sum

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to do a conditional sum.

I have 1000 rows of information in total.

and only 500 of them meets the criteria to be "real asset"

so what i want to do is to show the pie chart which has only "real asset" as the foundation and show how the "real asset" is divided into 3 categories.

so what I was thinking was

put the category as a dimension and

use a conditional sum in expression.

the conditional sum could be

if( #### = 'abc', 'def', 'ghi' and @@@@ = 'N' and $$$$ = '123', '456'), sum(count_row)

and I am not sure how to make use of conditional function. I can't get it to work.

help me please!!

Re: conditional sum

sunny_talwar — Tue, 07 Jun 2016 17:06:11 GMT

May be like this:

Sum({<#### = {'abc', 'def', 'ghi'}, @@@@ = {'N'}, $$$$ = {'123', '456'}>} count_row)

Re: conditional sum

Tue, 07 Jun 2016 17:11:10 GMT

Thank you Sunny this works!

Re: conditional sum

Tue, 07 Jun 2016 18:22:17 GMT

Hi sunny,

I have one follow up question. I want to add one condition. I want the condition to be $$$$ = Nullvalue. but I tried few things but I could not filter for columns with null values.

Can you help me with this?

Thanks!

Re: conditional sum

sunny_talwar — Tue, 07 Jun 2016 18:39:46 GMT

May be this:

Sum({<#### = {'abc', 'def', 'ghi'}, @@@@ = {'N'}, $$$$ -= {'*'}>} count_row)

Re: conditional sum

Tue, 07 Jun 2016 18:44:34 GMT

wow you used minus sign in from of equal sign.

the expression does not show error but once I apply it, it does not show any change.

I want to filter for the rows that have NULL for the column and my table obviously says NULL. I don't understand why this is not working in QV. all the other filters are working as you have explained but this null thing is not. hmmmmmmmm

is there any other possible way?

Thank you very much for your response!!

Re: conditional sum

sunny_talwar — Tue, 07 Jun 2016 18:47:15 GMT

May be try this:

Sum({<#### = {'abc', 'def', 'ghi'}, @@@@ = {'N'}, count_row = e({<$$$$ = {'*'}>})>} count_row)