Text Format Property QlikView

[#1]

Hi peoples,

I'm having an issue using the text format y pivot table that contains one dimension. The data is correctly related but I don't know why somethings records don't take the format.

The dimension i'm using is the customer name but my condition in the text format expression is with another field.

I just created an Test QV file to explaing more or less the issue.

[sunny_talwar]

Seems to be working with Customer 4 and Customer1 bolded?

[Oleg_Troyansky]

As far as I can see, the logic is working as expected - the two customers that are associated with Customer Type L1, are formatted as Bold, and the two other customers are not. Please explain what is not working?

cheers,

Oleg Troyansky

Upgrade your Qlik Skills with my book QlikView Your Business - An Expert Guide to QlikView and Qlik Sense..

[CarlosAMonroy]

Hi Julisy,

Based on your condition, the table is showing the format the way should be. What's the issue then?

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

[#5]

Yes, in this simple example it work, just shared you this text file to you see the structure but the data that I'm reading from de Database, there are records that has the customerType = L1 but don't appear with bold format.

I don't know why happends this. if you can help me I would be very grateful

[#6]

I would like to shared you my original Qv document but it use confidencial information of customer.

[CarlosAMonroy]

So then, you have to make sure it is really 'L1', could be an space in the cell or I do not know.

'L1 ' or  ' L1 ', ' L1'

Make sure is 'L1'

Thanks,

Carlos M

[sunny_talwar]

See if this addresses your confidentiality concerns

Preparing examples for Upload - Reduction and Data Scrambling

[antoniotiman · Accepted solution]

Hi,

May be

Customer:
LOAD * INLINE [
Customer, CustomerType, Total
Customer1, L1, 100
Customer2, L3, 200
Customer 3, L2, 400
Customer 4, L1, 300
Customer1, L2, 500 
];

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

Regards,

Antonio

[#10]

I just verified the record and it doesn't have space. I just tryied applying the Trim() funtion to delete blank space but is the same result.

Here is happening something weird because when i add the two dimensions, it work correctly but i don't want to display the customertype.