topic Re: Text Box how to add suppress when value is none ? in QlikView

Text Box how to add suppress when value is none ?

paulyeo11 — Thu, 05 Apr 2018 00:47:02 GMT

Hi All

Mt expression work fine , it display 14 :-

=count({<Reason-={'-'}>}Reason)

When i set the dimension suppress when value is none. The total become 9.

When i using the same expression for text box , it display 14 , how can i make it display 9 ?

Paul Yeo

Re: Text Box how to add suppress when value is none ?

sunny_talwar — Thu, 05 Apr 2018 00:57:47 GMT

May be this

=Count({<Reason = {"*"}>}Reason)

Re: Text Box how to add suppress when value is none ?

paulyeo11 — Thu, 05 Apr 2018 02:50:32 GMT

Hi Sunny

Your expression display 3000 plus.

Paul Yeo

Director

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: Text Box how to add suppress when value is none ?

sasiparupudi1 — Thu, 05 Apr 2018 02:56:53 GMT

Maybe

count({<Reason-={"=Len (Trim (Reason))=0"}>}Reason)

Re: Text Box how to add suppress when value is none ?

paulyeo11 — Thu, 05 Apr 2018 07:01:38 GMT

Hi SAS,

Thank you very much for your help.

I still not getting 9 and getting 3000+, enclosed My QVW.

Paul

Re: Text Box how to add suppress when value is none ?

Chanty4u — Thu, 05 Apr 2018 07:05:33 GMT

simply try this

=NullCount(value)

Re: Text Box how to add suppress when value is none ?

Chanty4u — Thu, 05 Apr 2018 07:05:51 GMT

=NullCount(Reason)

Re: Text Box how to add suppress when value is none ?

paulyeo11 — Thu, 05 Apr 2018 07:09:54 GMT

Hi chanty

I get 0 value.

Paul

Re: Text Box how to add suppress when value is none ?

PrashantSangle — Thu, 05 Apr 2018 07:10:29 GMT

Hi,

use below expression,

=count({<Reason-={'-'},StatusV={'Won'}>}Reason)

Regards,

Re: Text Box how to add suppress when value is none ?

paulyeo11 — Thu, 05 Apr 2018 07:12:16 GMT

Hi Pras

Wow you got it right.

Thank

Paul