topic Re: Hide data Expression or Script in QlikView

Hide data Expression or Script

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

Hello,

i have data that i need to hide but i don't know how to do that in expression or script what i want is

like if(BrancCode= 001') all having BranchCode = 001 should be hide.

Your help would be highly appreciated.

Regards,

Bing

Anil_Babu_Samineni — Tue, 25 Jul 2017 03:33:41 GMT

May be this?

Sample:

Load * from Source;

NoConcatenate

Final:

Load * Resident Sample Where BranchCode <> '001';

Drop Table Sample;

Load * From <Data Sample> Where BranchCode <> '001';

bsbernabe — Tue, 25 Jul 2017 04:59:48 GMT

Thank You So Much loveisfail I really appreciate ..

Anil_Babu_Samineni — Tue, 25 Jul 2017 05:53:08 GMT

Just to tell you can use Front end like

Sum({<BranchCode -= {'001'}>}Sales)

Only({<BranchCode -= {'001'}>}BranchCode)

mangalsk — Tue, 25 Jul 2017 05:55:32 GMT

I guess you don't want that data than to hide ,so as mentioned above you can excluding which loading data using where

Load *

from .... where

not exists(BranchCode ,'001')