topic hide or remove text in QlikView

hide or remove text

Anonymous — Thu, 16 Feb 2012 18:35:06 GMT

Hi,

Does anybody know how hide or remove text from table?

Other words, I have 3 string variables;

Var1 Var 2 Var 3

A ab abc

B bc cde

C cd qwe

D de asd.

I need to show only

Var1 Var 2 Var 3

A ab abc

B bc cde

D de asd.

Any thoughts?

Thanks,

Anonymous — Thu, 16 Feb 2012 18:39:55 GMT

mmm, in a straight table or table box??

mmm try this

Dimenssions= Var1 , Var2

Expressions = if(Var1<>'C',Var3)

and activate Supress Zero Values for the expression

Anonymous — Fri, 17 Feb 2012 02:18:17 GMT

Alternative, use dimension:
=aggr(if(Var1<>'C', Var1),Var1)
Use label Var1, and check "suppress if value is null

Anonymous — Tue, 21 Feb 2012 16:14:06 GMT

Hi guys,

I tryed to use your ideas, but they didn't work

I need to show like a table, where I can hide some varaibles.

My key variable is Var 2. But Order should be Var 1, Var 2 and Var 3.

Thanks,

Tue, 21 Feb 2012 18:26:57 GMT

var2 is a dimension or an expression?

you want to hide everything that starts with 'c'?

Anonymous — Tue, 21 Feb 2012 18:31:15 GMT

Hi Federico,

I found out issue.

Dimenssions= Var1 , Var2

Expressions if(Var1<>'C' and Var1<>'A' , Var3)

Thanks,