Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod2086
Creator II
Creator II

How to hide data

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

1 Solution

Accepted Solutions
sunny_talwar

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]);

View solution in original post

2 Replies
sunny_talwar

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]);

tresesco
MVP
MVP

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

];