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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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