Qlikview hide the row and Column values

[#1]

Hi All

I am new in  Qlikview so can you please give me some guidance . So Please find attachment

[#2]

Table: 

LOAD * INLINE [ 

    Variant, Customer, Sales 

   S1, Wilson, 12 

   S2, Johnny, 55 

   S3, Jenny, 6 

    S4, Mary, 4 

    S4, Rob, 33 

    S5, Dave, 44 

]; 

left Join(Table)

load distinct Customer, Sales as s1

Resident Table where Len(Sales)<=1;

[#3]

Hi,

Can you provide a sample qvw stating the exact requirement?

I have given an example based on what I understood.

I am implementing my logic based on following sample data.

load * inline

[

[@2]

4312,

4271,

2890010,

2789000,

2017

];

load *

resident A

where len([@2])<=4;

[PrashantSangle]

Hi,

You can remove those value by where clause

like

Load * from tableName

Where not wildmatch(fieldname,'2015*')

Regards

[prma7799]

Please try

Data:

LOAD * Inline [

Number,

4933,

4961,

5061,

5142,

20151108,

20151109,

20151110

]

Where not wildmatch(Number,'2015*')