topic How to hide data in QlikView

How to hide data

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

Hi team,

in my Req am using two inline tables but second table cust name is populating but for that custmoer there is no sales person but in my final report both r displaying so how to avoid karthik in my report pls find attached doc

Re: How to hide data

sunny_talwar — Wed, 31 Aug 2016 17:05:38 GMT

Not sure, but may be this:

LOAD * INLINE [

Sales per name, tar_cust, item, tar_amt

abc, vinod, Laptop, 200

xyz, vinod, printer, 300

cde, vinod, printer, 500

];

Left Join

LOAD * INLINE [

Trans, item, sales, cust name

1, Laptop, 100, vinod

2, printer, 100, vinod

3, printer, 200, vinod

4, printer, 400, karthik

]

Where Exists(tar_cust, [cust name]);

Re: How to hide data

tresB — Wed, 31 Aug 2016 17:10:29 GMT

Try like:

LOAD * INLINE [

Sales per name, tar_cust, item, tar_amt

abc, vinod, Laptop, 200

xyz, vinod, printer, 300

cde, vinod, printer, 500

];

Left Join

LOAD *,

[cust name] as [Sales per name]

INLINE [

Trans, item, sales, cust name

1, Laptop, 100, vinod

2, printer, 100, vinod

3, printer, 200, vinod

4, printer, 400, karthik

];