Text Format Property Pitvo Table

[#1]

Hi,

I'm having issue with the text format of dimensions.

When customerType is equal to L1 it has to take bold format but there are customer which has L1 but don't take this format.

I don't know why Qlikview isn't reconize those cases.

I just typed this expression in text format:

=if(WildMatch(Concat(DISTINCT CustomerType),'*L1*'), '<B>')

[sunny_talwar]

What is your dimension here? CustomerType?

[#3]

No.

My dimension is the customer name but each customer has his customertype.

I just verified what information is loading from DataSource and it has L1.

[sunny_talwar]

May be just this

If(CustomerType = 'L1', '<B>')

[#5]

I do that and the result is equal.

with this code:

=if(WildMatch(Concat(DISTINCT CustomerType),'*L1*'), '<B>')

You Ensure that wherever it has L1 will apply format; but really I don't know why qv not reconize this.

[sunny_talwar]

May be you are making selections

If(Only({1}CustomerType) = 'L1', '<B>')

[#7]

The expresion {1} is for all data... are you?

[#8]

Can I combine that expression with another field, that is, two validations?

Example:

If(Only({1}CustomerType) = 'L1' and Only({1}CustomerCompany) = 7, '<B>')

[sunny_talwar]

I think you should be able to... is this not working?