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

20 Replies
ivandrago
Creator II
Creator II
Author

Doesn't work I'm afraid

ivandrago
Creator II
Creator II
Author

Doesn't work I'm afraid

YoussefBelloum
Champion
Champion

what is missing on this app ?

big_dreams
Creator III
Creator III

what do you mean doesn't work??

can explain little bit more?

Regards,

ivandrago
Creator II
Creator II
Author

If you look at the attached, it is selecting NewTableName = "dbo.BSsignedUserAliBS" the Text box is showing that there is no _AreaFlag greater than 0 but the Sheet "Show Me" appears, it should only appearing when that value in the Text Box is greater than 0.

sunny_talwar

May be this

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

tresesco
MVP
MVP

You can use the same (as in textbox) expression as the conditional expression of the sheet.

=sum( {$<[_AreaFlag]={'1'}>} [_AreaFlag])

YoussefBelloum
Champion
Champion

ok,

this should work for you

=if(wildmatch(GetCurrentSelections(),'*'),1,0) and Concat(DISTINCT _AreaFlag)=1

PFA

sasiparupudi1
Master III
Master III

May be try

=(Index(GetCurrentSelections(','),'_AreaFlag: 1')>0 AND Index(GetCurrentSelections(','),'_AreaFlag: 1')<Len(GetCurrentSelections(',')))

big_dreams
Creator III
Creator III

did you try my suggestion???

where are your putting those expresssion??

it should be in show me sheet > property > general > conditional >

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

Regards