topic Re: If Only (....) = Only (....), something, null() - gives null for total. in QlikView

If Only (....) = Only (....), something, null() - gives null for total.

retko1985 — Fri, 29 Sep 2017 09:25:40 GMT

Hello,

the heading might be confusing, apologies here. There is a problem I am facing (see also attached QVW):

I am using expression like this in my straight table:

=if(Only(Country) = vAlternativeCountry,

Sum(Sales), null())

variable vAlternativeCountry contains: =Only({<City=$::City>}Country)

Also straight table is in Alternate state A.

The problem is that I get null for total.

I tried to use dimensionality () <> 0, but couldn't make it work.

Can someone help me to get the total there?

[Basically the table will show all cities of the country, when I select one city.]

[I kinda don't want to use p in set analysis]

Thank you for any help.

swuehl — Fri, 29 Sep 2017 09:29:55 GMT

Try this as expression

Sum({<Country = p({$}), City>}Sales)

Frank_Hartmann — Fri, 29 Sep 2017 09:31:42 GMT

sum(aggr(if( Only( Country) = vAlternativeCountry,Sum( Sales), null()),City))