topic Re: Text Format Property Pitvo Table in QlikView

Text Format Property Pitvo Table

Wed, 07 Jun 2017 19:50:16 GMT

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*'), '')

sunny_talwar — Wed, 07 Jun 2017 20:07:51 GMT

What is your dimension here? CustomerType?

Wed, 07 Jun 2017 20:17:46 GMT

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 — Wed, 07 Jun 2017 20:20:43 GMT

May be just this

If(CustomerType = 'L1', '')

Wed, 07 Jun 2017 20:24:38 GMT

I do that and the result is equal.

with this code:

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

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

sunny_talwar — Wed, 07 Jun 2017 20:28:02 GMT

May be you are making selections

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

Wed, 07 Jun 2017 20:43:21 GMT

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

Wed, 07 Jun 2017 21:31:36 GMT

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

Example:

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

sunny_talwar — Thu, 08 Jun 2017 09:09:30 GMT

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