topic Re: Qlikview hide the row and Column values in QlikView

Qlikview hide the row and Column values

Wed, 30 Dec 2015 06:04:49 GMT

Hi All

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

Re: Qlikview hide the row and Column values

Wed, 30 Dec 2015 10:06:22 GMT

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;

Re: Qlikview hide the row and Column values

Wed, 30 Dec 2015 10:11:33 GMT

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;

Re: Qlikview hide the row and Column values

PrashantSangle — Wed, 30 Dec 2015 10:12:12 GMT

Hi,

You can remove those value by where clause

Load * from tableName

Where not wildmatch(fieldname,'2015*')

Regards

Re: Qlikview hide the row and Column values

prma7799 — Wed, 30 Dec 2015 10:16:46 GMT

Please try

Data:

LOAD * Inline [

Number,

4933,

4961,

5061,

5142,

20151108,

20151109,

20151110

]

Where not wildmatch(Number,'2015*')