Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

Can anyone help please?

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?

Labels (1)
1 Solution

Accepted Solutions
IAMDV
Master II
Master II

Hi,

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

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

Cheers - DV

View solution in original post

2 Replies
Not applicable

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.

IAMDV
Master II
Master II

Hi,

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

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

Cheers - DV