topic IF NOT formula in QlikView

IF NOT formula

Tue, 24 Apr 2012 23:52:43 GMT

I'm trying to create a pie chart that sums all of a certain amount, exlcuding records for which "Package Config" = "No Package". The "Package Config" dimension is not used in the pie chart, just Supplier. The weird thing is: if I apply the formula below to a bar graph that has "Package Config" as one of the dimensions, it works perfectly.

Here is my attempt (not working for pie charts):

=if(not(PACKAGE_CONFIG = 'No Package'),sum(TOTAL_ALLOCATION))

What am I doing wrong? Can the IF NOT function only be used if the chart includes the dimension that I'm trying to qualify?

Also: I would love to do this using Set Analysis, but don't know how.

Thanks!

IF NOT formula

Wed, 25 Apr 2012 02:50:14 GMT

Hi...

can you give this a try?^^

Dimension tab:

Supplier (check "Suppress When Value is Null")

Expression tab:

sum({$<PACKAGE_CONFIG -={'No Package'}>} TOTAL_ALLOCATION)

Best Regards,

Alex

IF NOT formula

SunilChauhan — Wed, 25 Apr 2012 06:26:12 GMT

if((PACKAGE_CONFIG <> 'No Package'),sum(TOTAL_ALLOCATION))

its always better to write sum in starting

sum(if(PACKAGE_CONFIG <> 'No Package',TOTAL_ALLOCATION))