topic Re: Conditionally Show Sheet count of field greater than Zero in QlikView

Conditionally Show Sheet count of field greater than Zero

ivandrago — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Conditionally Show Sheet count of field greater than Zero

YoussefBelloum — Tue, 15 May 2018 09:45:31 GMT

Hi,

put this on the conditional display of that sheet:

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

Re: Conditionally Show Sheet count of field greater than Zero

big_dreams — Tue, 15 May 2018 09:49:03 GMT

Hi,

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

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

Regards

Re: Conditionally Show Sheet count of field greater than Zero

ivandrago — Tue, 15 May 2018 09:52:09 GMT

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.

Re: Conditionally Show Sheet count of field greater than Zero

juliensaintmaxent3113 — Tue, 15 May 2018 09:52:27 GMT

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())

have a nice day

Re: Conditionally Show Sheet count of field greater than Zero

big_dreams — Tue, 15 May 2018 09:56:50 GMT

try below

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

regards,

Re: Conditionally Show Sheet count of field greater than Zero

YoussefBelloum — Tue, 15 May 2018 09:59:59 GMT

try this:

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

Re: Conditionally Show Sheet count of field greater than Zero

tresB — Tue, 15 May 2018 10:00:31 GMT

I guess, you could try something like:

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

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

Re: Conditionally Show Sheet count of field greater than Zero

ivandrago — Tue, 15 May 2018 12:05:45 GMT

Doesn't work I'm afraid

Re: Conditionally Show Sheet count of field greater than Zero

ivandrago — Tue, 15 May 2018 12:05:54 GMT

Doesn't work I'm afraid

Re: Conditionally Show Sheet count of field greater than Zero

ivandrago — Tue, 15 May 2018 12:06:05 GMT

Doesn't work I'm afraid

Re: Conditionally Show Sheet count of field greater than Zero

ivandrago — Tue, 15 May 2018 12:06:11 GMT

Doesn't work I'm afraid

Re: Conditionally Show Sheet count of field greater than Zero

YoussefBelloum — Tue, 15 May 2018 12:09:54 GMT

what is missing on this app ?

Re: Conditionally Show Sheet count of field greater than Zero

big_dreams — Tue, 15 May 2018 12:15:12 GMT

what do you mean doesn't work??

can explain little bit more?

Regards,

Re: Conditionally Show Sheet count of field greater than Zero

ivandrago — Tue, 15 May 2018 12:21:11 GMT

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.

Re: Conditionally Show Sheet count of field greater than Zero

sunny_talwar — Tue, 15 May 2018 12:26:07 GMT

May be this

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

Re: Conditionally Show Sheet count of field greater than Zero

tresB — Tue, 15 May 2018 12:27:27 GMT

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

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

Re: Conditionally Show Sheet count of field greater than Zero

YoussefBelloum — Tue, 15 May 2018 12:30:08 GMT

ok,

this should work for you

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

PFA

Re: Conditionally Show Sheet count of field greater than Zero

sasiparupudi1 — Tue, 15 May 2018 12:32:49 GMT

May be try

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

Re: Conditionally Show Sheet count of field greater than Zero

big_dreams — Tue, 15 May 2018 12:38:34 GMT

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