Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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.

15 Replies
Not applicable
Author

jajajajaja thanks Antonio, it was the solution.

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

Now it work for all records.

Not applicable
Author

the communite for this foro don't display me the correct answer option. I will select as util

Anil_Babu_Samineni

Or,

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Hi, Antonio,

I'm having a issues with someone records; there are case who has L1 in customer type but this customer don't have sales for that month and QlikView is not formating in bold format.

are there someone way to indicate that don't considere if customer has sales or no?

antoniotiman
Master III
Master III

Try to uncheck 'Suppress zero values'

Not applicable
Author

When I'am checking the data in the QlikView document, it is bold format, but when generate a macro to export to pdf, it appear in normal mode.