topic Can anyone help please? in QlikView

Can anyone help please?

samvile18 — Fri, 23 Sep 2011 14:08:03 GMT

I have a list box named platform and a field named Total.

What I need to do is write an expression that checks to see if there is a selection within the product table, if there isn't then it needs to show the total figure.

Is this possible?

Can anyone help please?

Fri, 23 Sep 2011 14:11:07 GMT

Hi,

in the product table u have some field as dimension.

U can check them with getselectedcount(..) or getpossiblecount(..) in an other part of project.

C u,

Stefano.

Can anyone help please?

IAMDV — Fri, 23 Sep 2011 14:26:19 GMT

Hi,

I agree with Stefano. You need to use something like this...

=IF( GetSelectedCount(Product) > 0, Sum(Total), Something Else)

Cheers - DV