Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Format Property QlikView

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.

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

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

View solution in original post

15 Replies
sunny_talwar

Seems to be working with Customer 4 and Customer1 bolded?

Capture.PNG

Oleg_Troyansky
Luminary Alumni
Luminary Alumni

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
Creator III
Creator III

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-30-2017 9-51-44 AM.png

Not applicable
Author

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

Not applicable
Author

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

CarlosAMonroy
Creator III
Creator III

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
Master III
Master III

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

View solution in original post

Not applicable
Author

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.