Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ivandrago
Creator II
Creator II

Conditionally Show Sheet count of field greater than Zero

Hi,

I have the attached Document, I only want the sheet "Show Me" to appear if the Field "_Area Flag" has a value greater than zero when a Selection is made, if the values is equal to zero I do not want this sheet to appear.

Thanks

1 Solution

Accepted Solutions
sunny_talwar

May be this

=Len(Trim(GetCurrentSelections())) > 0 and _AreaFlag > 0

View solution in original post

20 Replies
YoussefBelloum
Champion
Champion

Hi,

put this on the conditional display of that sheet:

=GetSelectedCount(_AreaFlag)<>0 and GetFieldSelections(_AreaFlag)>0

big_dreams
Creator III
Creator III

Hi,

go to sheet property > general > conditional > write below expression

=if(GetFieldSelections(_AreaFlag)>0 and GetSelectedCount(_AreaFlag)=1,1,0)

Regards

ivandrago
Creator II
Creator II
Author

Thanks for your reply.

This works but only if you select the field _AreaFlag i.e. if I select the value 1, but I want it to work on any field selected as long as the total count for that field is greater than 0.

juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

Hi,

on the sheet which apperas vhen you select a value, you enter in propertie and you write this :

=sum(_AreaFlag)>0 and not isnull(GetCurrentSelections())

2018-05-15_11h51_47.png

have a nice day

big_dreams
Creator III
Creator III

try below

=if(sum(DISTINCT _AreaFlag)>0,1,0)

regards,

YoussefBelloum
Champion
Champion

try this:

=if(wildmatch(GetCurrentSelections(),'*'),1,0)

tresesco
MVP
MVP

I guess, you could try something like:

=SubStringcount(GetCurrentSelections('',',') ,',')

With this you can get actually how many values from different fields are selected.

ivandrago
Creator II
Creator II
Author

Doesn't work I'm afraid

ivandrago
Creator II
Creator II
Author

Doesn't work I'm afraid