Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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

View solution in original post

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